Support for SQL Compact Edition


Author
Message
Bastian Töpfer
Bastian Töpfer
StrataFrame Beginner (32 reputation)StrataFrame Beginner (32 reputation)StrataFrame Beginner (32 reputation)StrataFrame Beginner (32 reputation)StrataFrame Beginner (32 reputation)StrataFrame Beginner (32 reputation)StrataFrame Beginner (32 reputation)StrataFrame Beginner (32 reputation)StrataFrame Beginner (32 reputation)
Group: Forum Members
Posts: 32, Visits: 107
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

Bastian Töpfer
Bastian Töpfer
StrataFrame Beginner (32 reputation)StrataFrame Beginner (32 reputation)StrataFrame Beginner (32 reputation)StrataFrame Beginner (32 reputation)StrataFrame Beginner (32 reputation)StrataFrame Beginner (32 reputation)StrataFrame Beginner (32 reputation)StrataFrame Beginner (32 reputation)StrataFrame Beginner (32 reputation)
Group: Forum Members
Posts: 32, Visits: 107
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.
Trent Taylor
Trent Taylor
StrataFrame Developer (7.1K reputation)StrataFrame Developer (7.1K reputation)StrataFrame Developer (7.1K reputation)StrataFrame Developer (7.1K reputation)StrataFrame Developer (7.1K reputation)StrataFrame Developer (7.1K reputation)StrataFrame Developer (7.1K reputation)StrataFrame Developer (7.1K reputation)StrataFrame Developer (7.1K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 6.9K
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.
Marcelo Blank
Marcelo Blank
StrataFrame Novice (62 reputation)StrataFrame Novice (62 reputation)StrataFrame Novice (62 reputation)StrataFrame Novice (62 reputation)StrataFrame Novice (62 reputation)StrataFrame Novice (62 reputation)StrataFrame Novice (62 reputation)StrataFrame Novice (62 reputation)StrataFrame Novice (62 reputation)
Group: StrataFrame Users
Posts: 0, Visits: 414
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';
Edited 11 Years Ago by Marcelo Blank
Marcelo Blank
Marcelo Blank
StrataFrame Novice (62 reputation)StrataFrame Novice (62 reputation)StrataFrame Novice (62 reputation)StrataFrame Novice (62 reputation)StrataFrame Novice (62 reputation)StrataFrame Novice (62 reputation)StrataFrame Novice (62 reputation)StrataFrame Novice (62 reputation)StrataFrame Novice (62 reputation)
Group: StrataFrame Users
Posts: 0, Visits: 414
Provider=Microsoft.SQLSERVER.CE.OLEDB.3.5;Data Source=Path\database.sdf;"SSCE: Database Password='123456';"
Edited 11 Years Ago by Marcelo Blank
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search