Click here to Skip to main content
15,905,563 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
My application got a mdf database file. I want to connect to it without SqlServer installed. How can I connect to .mdf database using SqlServer compact?

1 solution

If you created the database in a edition of SQL Server OTHER THAN Compact, you cannot use it with the Compact edition. CE only supports SDF files. I'm not aware of any utility that converts between the two formats.
Share this answer
Pooya F.A 7-Jul-12 15:15pm    
So how can I connect to SDF files?
Dave Kreskowiak 7-Jul-12 17:32pm    
You have to install SQL Server Compact Edition.

Your connection string would be something like
"Provider=Microsoft.SQLSERVER.CE.OLEDB.3.5;Data Source=myPath\myData.sdf;"

I believe you're stuck using the OleDbxxxxx database classes. You cannot use the Sqlxxxx classes.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900