On some computers application can't load sqlite dll file

c# sqlite deployment system.data.sqlite
David Božjak picture David Božjak · Oct 25, 2009 · Viewed 8.3k times · Source

I wrote an application that uses sqlite and it works great on most of the systems. It is written in C#, and the only non-framework assembly is sqlite, which is included by System.Data.SQLite.dll .

I deploy it the same way on all of the machines (copy pasting the exe file, the database file and the System.Data.SQLite file). It works great for all my PC's and most of the PC's I've tried.

But then I've got reports that for some people it throws the following exception:

Could not load file or assembly 'System.Data.SQLite, Version=1.0.65.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139' or one of its dependencies. An attempt was made to load a program with an incorrect format.

Now I've made sure the dll file is in the same folder than the application exe file. It's the same dll, with the same version as stated in the exception message above.

I was really confused by this, so I created a fresh virtual machine, installed windows 7 professional on it, and just copy pasted the files, and the thing worked. So if it works on a fresh windows, I can't imagine what the other PC's could be missing...

Note: Two of those machines where the project throws the exception are also running windows 7 proffesional.

I would really appreciate any help on this, because I'm fresh out of ideas...

Answer

RichieHindle picture RichieHindle · Oct 25, 2009

Here's a possibility: Is the difference between the working and not-working machines 32-bit vs. 64-bit? Are you building for "Any CPU", when you should be building for just the bitness of your external DLL?

Related questions

System.Data.SQlite for Visual Studio 2013

The current distribution for System.Data.SQLite does not work with Visual Studio 2013 unless you deploy the VS2012 Update3 release pack (presumably) or just install (on a test machine like I did) the full version. Does anyone know when the …

Read More
Create SQLite Database and table

Within C# application code, I would like to create and then interact with one or more SQLite databases. How do I initialize a new SQLite database file and open it for reading and writing? Following the database's creation, how do …

Read More
Unable to load DLL 'SQLite.Interop.dll'

Periodically I am getting the following exception: Unable to load DLL 'SQLite.Interop.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E) I am using 1.0.82.0. version, installing it with nuget in VS2010, OS Win7 64. Once exception …

Read More