Wednesday, March 10, 2010

Requirements for SQL Compact installations on x64 systems

For x64 based computers with SQL Compact, it is important that both the x86 and x64 MSIs are installed and that both the x86 and x64 MSIs are of the same version.

Otherwise you will get errors like: “Version mismatch exception” (new in SQL Compact 3.5 SP2) or “Unable to load DLL ‘sqlceme35.dll’”. Read more here.

Notice that installing Visual Studio 2010 Beta 2 will upgrade the installed version of SQL Compact (3.5 SP1 or 3.5) to 3.5 SP2, but only for x86, so if the x64 version is also installed, it will not be upgraded, causing a version mismatch.

No comments: