SQL Compact 4.0 can't open/read sdf file

visual-studio-2010 sql-server-ce
Andre Vianna picture Andre Vianna · Nov 1, 2010 · Viewed 20.3k times · Source

I've installed SQL Compact 4.0 CTP 2 via WPI and used NUPack to add SQLCE.EntityFramework in my project. It compiles and run perfectly but I can't open the SDF file in Visual Studio 2010's Server Explorer.

When I try I always receive the following message:

Microsoft Visual Studio

This is not a valid SQL Server Compact Database file or this file version is not supported by current SQL Server Compact Engine.

OK

I've already tried to uninstall and reinstall everything.

It cannot be opened in SQL Server 2008 R2 Management Studio also.

Please help!!

Answer

user74754 picture user74754 · Aug 18, 2012

Installing this (Visual Studio 2010 SP1 Tools for SQL Server Compact 4.0) fixed this exact problem for me perfectly: http://go.microsoft.com/fwlink/?LinkId=212219

Props to ErikEJ from this thread: http://forums.asp.net/t/1811963.aspx/1

Related questions

How can I upgrade my Sql Server CE 3.5 sdf database to Sql Server CE 4.0?

I need to update my SqlCE3.5 database to 4.0. I get the following error message when I'm trying to access my 3.5 sdf/database using the new CE4.0 connection provide :- System.Data.EntityException: The underlying provider failed on Open. ---> …

Read More
The type or namespace name could not be found

I have a C# solution with several projects in Visual Studio 2010. One is a test project (I'll call it "PrjTest"), the other is a Windows Forms Application project (I'll call it "PrjForm"). There is also a third project referenced by …

Read More
Error 'LINK : fatal error LNK1123: failure during conversion to COFF: file invalid or corrupt' after installing Visual Studio 2012 Release Preview

I've installed Visual Studio 2012 Release Preview, and it appears to be fine, but now when I try to use Visual Studio 2010 to compile C++ projects, I get the following error message: LINK : fatal error LNK1123: failure during conversion to COFF: …

Read More