System.Data.SQLite

I am getting this error when trying to use the system.data.sqlite dll.  It works fine on my dev box, but on the webserver...no dice.  I tried adding it to the GAC...which I think I did successfully...but I really don't know how to tell.  Any advice? 

You must be using the managed-only version of the DLL?  If so you also need to copy over sqlite3.dll from sqlite.org's website.  Or alternatively, use the mixed-mode DLL I also provide which contains both the native and managed library rolled into one.

 

For those of you who run into this problem, the following steps solved my problem.

1.  Copy the mixed-mode (not managed only) version of the system.data.sqlite.dll into the framework/v???  folder
2. Make sure the gacutil is in the same folder
3. go to command line, navigate to the folder that contains both the gacutil and the system.data.sqlite.dll
4. run the following command gacutil /i system.data.sqlite.dll
5. If successful....then it should run fine.

Side note: Make sure you reference the gac registered location in your project or it won't work.

I had the same problem, and found little or no help on all the forum and blog posts. Note that this problem is specific to a case respecting *all* of the following criteria: - using SQLite - with System.Data.SqlLite - on an x64 machine - and NHibernate (2.1.2.4 in my case) That chunk of config in my web.config (or app.config for my unit tests) got it to work. I had to qualify the assembly to be sure he loads correctly. <configuration> <runtime> <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1"> <qualifyAssembly partialName="System.Data.SQLite" fullName="System.Data.SQLite, Version=1.0.66.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139, processorArchitecture=AMD64" /> </assemblyBinding> </runtime> </configuration> Somewhere in it's inner plumbing, during the mapping using scanned assemblies, NHibernate creates an Assembly object using it's paritla name, as a string, "System.Data.SQLite". Somehow, the x86 version of the assembly got loaded. The above configuration made sure that using the partial name to load an assembly would provide the x64 version.