I am trying to make project in sql server compact. And i am completely Noob in sql server compact. I know how to use sql server express edition but Don't know anything about compact.
I am trying to access SDF file in my visual Studio c# Application, But it gives me this error.
You are trying to access older version of sql server compact edition databse.if this is sql server Ce 1.0 or 2.0 databse,Run upgrade.exe.if this is sql server compact edition 3.0 or later than run repair.[db version=400000 requested version=3004180,filename="path of file here"]
The version of databse file is 4.0 and the sql server edition on my pc is 4.0 as well. I just installed sql server compact 4.0 from microsoft site.http://www.microsoft.com/en-us/download/details.aspx?id=17876. still its not working.
I am totaly lost. Please Help
P.S: Please Give me Some links where i can learn things about sql server compact.
Thanks in advance.