StrataFrame Forum

Support for SQL Compact Edition

http://forum.strataframe.net/Topic11439.aspx

By Bastian Töpfer - 9/12/2007

Hi,

today I finally found the time to look at the SQL Compact Edition. I think it is a quite interesting concept and it will be useful for a lot of small desktop apps that dont need an server/client environment. Since I really enjoy programming with SF I wanted to try if it works to create BOs with a CE Source. But I failed Sad So either I've done something wrong (hints would be very welcome) or SF just really doesnt support it. If it doesnt I think you should really consider it.

thanks

By Bastian Töpfer - 9/12/2007

Well.....
 
I did get it to work now. After it didnt work with the SQL Server Connection String I tried the OLEDB and it worked
The OLEDB Connection Strings for the Compact Edition are looking like this:
 
Provider=Microsoft.SQLSERVER.MOBILE.OLEDB.3.0;Data Source=myPath\myData.sdf;
 
So sorry to bother you with the earlier post. I just thought a Sql Server Connection String like this:
Data Source=MyData.sdf;Persist Security Info=False;
would also work, since VS is using it.
By Trent L. Taylor - 9/12/2007

You got it, it just requires that you use the OLEDB provider.  There are times that this model can be useful when you do not need the support for multiple users, a server, etc.
By Marcelo Blank - 1/20/2013

Update the information:



Connect String withSQL Compact 3.5 and Password:



Provider=Microsoft.SQLSERVER.CE.OLEDB.3.5;Data Source=Path\Database.sdf;SSCE: Database Password='123456';
By Marcelo Blank - 1/20/2013

Provider=Microsoft.SQLSERVER.CE.OLEDB.3.5;Data Source=Path\database.sdf;"SSCE: Database Password='123456';"