StrataFrame Forum » StrataFrame Application Framework - V1 » Enhancement Requests » Support for SQL Compact Edition

Support for SQL Compact Edition

Bastian Töpfer — Thu, 07 Feb 2013 11:09:04 GMT

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 :( 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

RE: Support for SQL Compact Edition

Marcelo Blank — Sun, 20 Jan 2013 10:02:09 GMT

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

RE: Support for SQL Compact Edition

Marcelo Blank — Sun, 20 Jan 2013 10:01:04 GMT

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';

RE: Support for SQL Compact Edition

Trent L. Taylor — Wed, 12 Sep 2007 09:27:29 GMT

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.

RE: Support for SQL Compact Edition

Bastian Töpfer — Wed, 12 Sep 2007 08:27:47 GMT

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.