Unable to Load 64bit version 1.1 possibly due to VSTADB being 32bit

[atifaziz]

Originally reported on Google Code with ID 142

I downloaded the latest version (1.1 x64 Aug 17) I can can't build the 64
bit version due to bad image reported in Studio:

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

When I look at VSTADB.NET20.DLL using the 64bit version of Depends.exe it
reports that vstadb is x86 and not x64. 

Please advise 

Reported by william.wegerson on 2009-11-24 20:03:16

[atifaziz]

If you're using the SQLiteErrorLog, you do not need to deploy the VistaDB-related 
files. Does it resolve the problem if you delete them?

Also note that VistaDB is being dropped going forward. See issue #131 for details.

Reported by azizatif on 2009-11-24 21:10:31

• Labels added: Type-Defect
• Labels removed: Type-Enhancement

[atifaziz]

I get the same problem and I have no reference to either SQLite or the VistaDB dlls
and I'm only configured to use the SQLErrorLog.

Reported by drew.freyling on 2010-03-09 00:31:43

[atifaziz]

Is there a solution to this problem? I just grabbed Elmah off NuGet, and GoogleCode,
both throw the same exception even tho i'm configured for SQL Server, not SQLite. 

The exception is thrown with and without a reference to the sqlite assembly...

Reported by phillip.haydon on 2011-01-03 07:46:32

[atifaziz]

Simply delete the SQLite and VistaDB DLLs as you don't need them!

Reported by jamesdriscoll71 on 2011-01-03 11:24:52

[atifaziz]

I'm assuming this problem is occuring during development with Visual Studio and not
in a deployed IIS environment. Is that correct? If yes, could you please provide more
details about when this error is thrown? For example, is it during a build? Is it when
run the web site using the built-in Development Server?

Reported by azizatif on 2011-01-03 17:43:28

[atifaziz]

Reported by azizatif on 2011-01-03 21:27:33

• Status changed: NeedsInfo

[atifaziz]

I cannot get it to work in Visual Studio. What is the fix?

Reported by balderdash on 2011-01-20 17:37:34

[atifaziz]

I have the same problem.  I build on a 32-bit machine and deploy to a 64-bit machine.
 The SQLite DLL isn't required on my 32-bit machine, but is on the 64-bit.  FYI, I
do a manual deploy to a bank of IIS servers.

I don't care about the dependency on SQLite, but having to manually add it to the deploy
is a pain.  

Seems the ideal solution is to use a non-platform dependent version of SQLite:
http://code.google.com/p/csharp-sqlite/

Reported by masilver on 2011-12-05 16:49:45

[atifaziz]

Can you be more specific about "The SQLite DLL [...] is on the 64-bit" please?
What messages are you seeing?

Also, have you tried adding ELMAH to your project using the NuGet packages?
Does this make any difference??

Thanks,

James

Reported by jamesdriscoll71 on 2011-12-05 17:35:17

[atifaziz]

I am running version ELMAH-1.2-sp1-bin-x64 and experiencing the same issue on my local
64bit development machine.  The error is occurring during the build/rebuild of my web
project.  Even after manually deleting the references to System.Data.SQLite since I
am not using it when rebuilding Visual Studio re-adds the references ( I guess the
other DLLs require it to part of the build).  I have attached a text file that contains
the exception details, stack trace, etc.

Please assist.

Reported by dansmith.757 on 2012-01-24 16:59:23

---

- _Attachment: [System_Data_SQLite Issue.txt](https://storage.googleapis.com/google-code-attachments/elmah/issue-142/comment-10/System_Data_SQLite Issue.txt)_

[atifaziz]

Dear Elmah Developers -- Please help. This is still an issue for me too-- "Could not
load file or assembly 'System.Data.SQLite' or one of its dependencies. An attempt was
made to load a program with an incorrect format". My setup and result is pretty much
exactly as described above in "Comment 10 by [email protected], Jan 24, 2012".
Is there a workaround? Please advise. Thanks. -- Mark Kamoski

Reported by mkamoski on 2012-07-27 20:13:23

[atifaziz]

Hi there!

If you don't need SQLite, simply delete the SQLite DLL.
If you need SQLite, your best bet is to use the NuGet packages.

Cheers,

James 

Reported by jamesdriscoll71 on 2012-07-28 07:22:17