unable to load DLL ‘sqlceme35.dll ?

Question

I have a home-based business and I just got a new computer with Windows 8.1. I had this software called "My Invoices and Estimates Deluxe 10" running on my old Windows XP and everything was fine. When I tried to create a company, it says "unable to load DLL ‘sqlceme35.dll".. I called the maker of the software and they said to contact Microsoft... 

Any ideas on what I could do?

Answer 1

 "unable to load DLL ‘sqlceme35.dll"..

Hello,

That's an assembly of "Microsoft SQL Server Compact Edition, Version 3.5" and should be installed with the application.

You can download it also here: Microsoft SQL Server Compact 3.5 Service Pack 2 for Windows Desktop

---

Olaf Helper

[ Blog] [ Xing] [ MVP]

Answer 2

Hi pibitrans,

According to your error message, “The Unable to load DLL ‘sqlceme35.dll’ error occurs in .NET applications because the assembly used to compile the sqlceme35 module (System.Data.SqlServerCe), actually references .NET Framework 2.0 in the code. So I recommend you install .NET Framework 2.0 on the Server for fixing this error.

If you have SQL Server Compact installed on your machine, they are most likely located at "C:\Program Files\Microsoft SQL Server Compact Edition\v3.5". They can be added to the project in Visual Studio and then set their project output type to "copy always". And the main reference to System.Data.SqlServerCe that you have in your project references should have copy local set to true.

•sqlceca35.dll

•sqlcecompact35.dll

•sqlceer35en.dll

•sqlceoledb35.dll

•sqlceqp35.dll

•sqlcese35.dll

There is detail about how to deploy a SQL Server Compact Edition database with an application, you can review the following article.

http://msdn.microsoft.com/en-us/library/aa983326%28VS.80%29.aspx

Regards,
Sofiya Li

---

Sofiya Li
TechNet Community Support