Question can't connect to SQLCE

ferreirah

New member
Joined
Jul 1, 2008
Messages
2
Programming Experience
10+
Is it ok to post a question about VB.Net Express here? I got both the 2005 and 2008 editions. According to what I read in pdf docs it looks like it is possible to
connect to SQL Server Compact Edition with VB.Net Express. According to what I read it looks like it is possible to create a desktop Windows app that connects to SQLCE. I got SQL Server 2005 Express sp2 and it looks like it automatically installed SQLCE with it. I was able to create a SQLCE database with SQL Server managament studio express. Unfortunately when I go add new data source I am unable to connect to SQLCE. It doesn't even allow me to choose the SQLCE provider. The only providers it lists is Access (JET4) and SQL Express. Also how do I know which version of SQLCE I got? Can you connect to SQLCE WITHOUT the mobile dot net emulator which only ships with the paid version of Visual Studio? A friend of mine says he was able to connect with C# Express to SQLCE. I also downloaded the version 3.1 (2005) version of SQLCE and installed it. Still no luck. I want to use SQLCE with the dot net 2.0 framework with a desktop Windows app.
 
Surely you'd attempt to use the SQL Server connector? SQLS, MSDE, SQLSX, SQLCE are all merely flavours of SqlServer?
 

Latest posts

Back
Top