.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Sql Server Compact Edition 4.0 bug?

Posted By:      Posted Date: May 22, 2011    Points: 0   Category :

Not sure where to report this issue. I could not find a bug database on Microsoft Connect.  Although I found a work around, I'm wondering if anyone has any other ideas.

When using nunit-x86.exe and VS 2010 + .NET 4.0 to debug unit tests using SQL Server Compact Edition 4.0 privately deployed, I get the following error:

"Unable to load the native components of SQL Server Compact corresponding to the ADO.NET provider of version 8482. Install the correct version of SQL Server Compact. Refer to KB article 974247 for more details."

(Note that it would be nice if the article actually applied to SQL Server CE 4.0 - but that's another topic.)

I spent lots of time trying to track this down, and finally was able to work around the issue by changing my unit test dll to compile for x86 instead of Any CPU.  Note that the issue does not manifest itself when I'm not running under the VS 2010 debugger.  To confirm that I'm running in 32 bit mode, I checked the System.Environment.Is64BitProcess property.

I'm pretty sure that SQL Server CE 4 is looking for the amd64 dlls because when I added them to the private deploy directory, I began getting the BadImageFormatException.  And this seems obviously incorrect, since we are running in 32 bit mode.

I guess it would be nice to know more specifically what heuristic S

View Complete Post

More Related Resource Links

ODBC Driver for SQL Server Compact Edition

I know that there is no ODBC driver available for SQL Server Compact Edition version 3.5.  Do you plan to add an ODBC driver in future release? If yes, is it high in your priority list?   The scenario why I am looking for an ODBC driver is to connect an MS Access application to a SDF file instead of MDB file.  This will enable me to easily sync the SDF file with SQL server repository using the new Data Sync Services.   Mario Cardinal MVP Solutions Architect

SQL Server to SQL Server Compact Edition Database Copy

I recently switched from XP to Win 7 and am getting an error when using the SQL Server to SQL Server Compact Edition Database Copy wizard from johnnycantcode.com (link). I suspect that the problem is with the configuration of the path for the DQL CE dll. 1) Does anyone know where the configuration is set? It isn't in the GLT.SqlCopy.exe.config file in the local directory. 2) Has anyone got the program to run under Win 7? Thanks marc  

Cannot select 'SQL Server Compact Edition' from Server Type drop down

I have seen this issue addressed for SQL Server 2005 but not 2008. I have installed these components:SQL Server 2008 (Browser, Management Objects, Native Client, Policies and Setup Support Files)SQL Server Compact 3.5 (for Devies, Server Tools and SP1)In the SQL Server Management Studio, on the Connect to Server dialog, the "Server Type" drop down list is disabled and "Database engine" is the default. Does anyone know what I need to do to make "SQL Server Compact Edition" a choice in the "Server Type" drop down list?

SQL Server Compact Edition ORM

Hi!I need an ORM library for SQL CE 3.5 SP1. Are there any solutions available?Regards,Dawid Ireno

Introducing SQL Server Compact Edition 4

Hi, I just downloaded the above but when I look in visual web developer 2010 express I see no data provider reference . I was wondering how to attach/create db? in the above, is it a clickable option in tools .net framework options or is VS 2010 not ready to use SQL CE 4 yet, Any help/suggestions/your time in anwering this question greatly appreciated    

Can a row on a "SQL Server Compact Edition 3.5" have more than 8000B in size ?

Hello, I am trying to use SQL Server Compact Edition 3.5 for a desktop PC application. I need to have a table with 5 columns. One of this columns will contain a data that can grow up to 1MB in size. I have read in wikipedia specifications that the maximum row size, this engine is capable to handle, is of 8000B. However, when designing the table, I can choose "image" type. So, can a row on that table have more than 8000B in size? Is there a maximmum limit ? Cheers Valentin

SQL server 2008 compact editioin + Entity Framework: Can we backup the SQL server compact edition da

our application uses the SQL server 2008 compact edition and entity framework. The application will control the instrument. It may run for several days before it stops. In order to protect the database crash (database failure), we plan to backup SQL compact database during running. Can we backup or duplicate the ~.sdf when application is running? Is there any SQL server command we can call inside the application to achive the backup? Or we only can backup the database when application is not running. thx!  

Using Sql Server Compact Edition 4 as Datasource



Is it possible to connect to Sql Server Compact Edition 4 and use it as Datasource? I'm able to connect to SQL CE 3.5 but not to the version 4.


Thanks in advance.


Using SQL Server Compact Edition 4.0



I was new to WPF and ADO.NET Entity Framework,

I was developing a WPF application in SQL Server Compact Edition 3.5 and connect with LINQ to Entities ,

I was thinking to migrate my database to SQL Server Compact Edition 4.0, can i remain the model i created in CE3.5  and directly adopt the CE 4.0 into my application?

If yes, may I know any references i should add in my project?

Microsoft SQL Server Compact Edition & CE6


I have an issue on a Janam barcode scanner (wifi) with an App I have written, it appears the realtime SQL login screen intermittently puts a call onto the network when we run it on CE6. When we run the same app on a Psion scanner with CE5 it works every time. I get the feeling its an SQL timing issue / lockout on the local client as no network traffic happens when it occurs, we restart the app and it sometimes works ??

The app is written in VS2008, the framework is v3.5, the cab on the terminal is sqlce.wce5.armv4i.CAB. there is currently no wce600 build but reading up the wce500 should be OK with ce6 ???

Anyone know of any SQL issues like this or what stops the connection to the SQL Server on the network?

Sql Server compact Edition Performance issue

I was  trying to insert a .wav file to sql server CE..The file is of size 1 Mb,but it takes a long time to perform the action (more than 1 min).Anybody have solution ? please help me..

Query sql server compact Edition version



I want to know what is the query for sql server compact Edition version..Any help will be apreciated


Query sql server compact Edition version



I want to know what is the query for sql server compact Edition version..Any help will be apreciated


Checking if SQL Server 2005 Compact Edition 3.1 (CE) is installed


I am developing a Windows desktop application which requires the SQL Server 2005 Compact Edition (SQLServerCE31-EN.msi) to be installed. I am using InstallShield 2011 to install this as a pre-requisite during the installation process.

In order to come up with the pre-requisite definition I used Process Monitor to see that these registry locations are checked when SQLServerCE31-EN.msi is run manually (not via the installer):

32-bit: HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server Compact Edition\v3.1

64-bit: HKEY_LOCAL_MACHINE\Software\Wow6432Node\Microsoft\Microsoft SQL

SQL Server Compact Edition with Multiple connexion - SQL Server Express without install...



I have develop a Delphi tool that allow to manage enterprise timesheet. 

This application is used by multiple different user in an enterprise. 

The tool can run under SQL Server 2000,2005, 2008 (express or not).

In my SQL queries within my application, there is a lot of "INNER JOIN", "OUTER JOIN" that is quite universal. 
But there is also some "ISNULL(?,!)", "CASE WHEN ... .THEN ... ELSE .. .END".

I want to have a "free trial" version of my tool.

I can't ask my users to install SQL Server (it is a free trial).

I am not able to use SQL Server Compact Edition because I need a multi-computer connexion (each different employes of a company access the tool).

I dont really like ACCESS because there is some standard not respected (varchar datatype do not exist, memo field is not easy to manipulate compare to varchar(2000), CASE WHEN dont work, I have to make weird query junction with parenthesis when there is multiple table, etc...etc...etc...).

My question : WHAT CAN I DO!  I dreamed of SQL Server Compact Edition allowing multiple concurrent connexion and handling tables.  Or SQL Server Express without install.


Is there a solution to this?

SQL Server Compact Edition Device Deployment


We're building a custom PC installation package to deploy our .NET Compact Framework 3.5 / SQL Server Compact Edition based application.  The installation package uses the System.Configuration.Install and calls Process.Start(ceAppPath, iniPath). We are targeting ARM and x86 devices.  Specifically, which SQL Server Compact Edition cab files do we need to install/deploy for our application to run on the these device platforms?

Entity Framework + SQL server 2008 compact edition: limitation?


any limitation with SQL Server 2008 compact edtion with Entity Framework 4?


ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend