1

I've installed the SQL Server Compact Edition 4.0 runtime and DbFactory provider and everything.

But after I've installed the SQL Server CE Toolbox (v3.2) from CodePlex, I still cannot seem to get any connections established.

The info dialog seems to indicate everything's fine and dandy....

enter image description here

but when I tried to open a new connection to an existing .sdf database file, I cannot seem to do that from within Visual Studio 2010 (SP1):

enter image description here

The SQL Server CE Toolbox stand-alone app works just fine on that very machine - just the VS plugin doesn't seem to be functioning. Any ideas?

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459

2 Answers2

1

The Toolbox add-in needs the 3.5 DbProvider for storing custom connections and other functionality (This is for historical reasons, the assunption being that 3.5 SP2 is installed and registered with VS 2010 RTM). And the 3.5 DbProvider is not properly installed on your system (as the about dialog shows). So repair/re-install the 3.5 SP2 Desktop runtime - and remember to install both the x86 and x64 MSI files.

ErikEJ
  • 40,951
  • 5
  • 75
  • 115
  • +1 perfect - that worked - thanks! It's a bit confusing - but at least it works just fine now! :-) – marc_s Feb 24 '13 at 21:29
  • I will show a permanent warning that this required component is missing in the next release. Normally it's not broken... – ErikEJ Feb 25 '13 at 09:55
  • 1
    The next version of the Toolbox, currently in Alpha, no longer requires 3.5 SP2, it can work with either 4.0 or 3.5 installed. – ErikEJ Dec 19 '13 at 11:50
0

I installed via NuGet "Microsoft SQL Server Compact Edition" and SQL CE Toolbox had the same problem.

I corrected the problem by downloading directly from Microsoft SQL CE (NOT via Nuget)

Microsoft SQL Server Compact 4.0 from Microsoft here
or Microsoft SQL Server Compact 3.5 Service Pack 2 for Windows Desktop here

Guish
  • 4,968
  • 1
  • 37
  • 39