10

I have installed the sp1 for visual studio 2010 and installed sql server ce 4 runtime. But still not able to create connection to the sql ce database using standart data provider.

This is how my Select DataProvider Dialog looks like now. Change data source dialog

P.S. Does not know if it matters, but I have tested this with console application and winforms application both targeted at .Net 4.0

Cœur
  • 37,241
  • 25
  • 195
  • 267
v00d00
  • 3,215
  • 3
  • 32
  • 43

3 Answers3

10

You must install the SQL Server Compact 4 tools via Web PI, as described here: http://erikej.blogspot.com/2010/12/visual-studio-tools-for-sql-server.html

ErikEJ
  • 40,951
  • 5
  • 75
  • 115
3

You can use this project/Tool to open/create sql ce databases:

SQL SERVER CE QUERY TOOL

And have a look at this:

Everything SQL Server Compact

Regards

Crimsonland
  • 2,194
  • 3
  • 24
  • 42
  • This can be helpfull, but this one should be supported by visual studio, or atleast ms sql server management studio (which is also installed). I do not belive that technology creator does not include it support in tooling. – v00d00 Mar 20 '11 at 23:23
  • Yup this is just a tool even without visual studio and ssms. But its function is almost the same and easy to use as what we are using ssms. – Crimsonland Mar 20 '11 at 23:28
0

Another option, just install the extension SQL Server Compact & SQLite Toolbox

from here http://sqlcetoolbox.codeplex.com or over VS Add Extension.

Stefan Michev
  • 4,795
  • 3
  • 35
  • 30