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

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.

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.

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