Could not load file or assembly 'System.Data.SQLite' or one of its dependencies


#1

There is a runtime error of WebForms example code. However, there are no errors at compile time.

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.

=== Pre-bind state information ===
LOG: User = IIS APPPOOL\ASP.NET v4.0
LOG: DisplayName = System.Data.SQLite
 (Partial)
WRN: Partial binding information was supplied for an assembly:
WRN: Assembly Name: System.Data.SQLite | Domain ID: 4
WRN: A partial bind occurs when only part of the assembly display name is provided.
WRN: This might result in the binder loading an incorrect assembly.
WRN: It is recommended to provide a fully specified textual identity for the assembly,
WRN: that consists of the simple name, version, culture, and public key token.
WRN: See whitepaper http://go.microsoft.com/fwlink/?LinkId=109270 for more information and common solutions to this issue.
LOG: Appbase = file:///C:/Users/dtuso/Documents/MiniProfiler/Sample.WebForms/
LOG: Initial PrivatePath = C:\Users\dtuso\Documents\MiniProfiler\Sample.WebForms\bin
Calling assembly : (Unknown).
===
LOG: This bind starts in default load context.
LOG: Using application configuration file: C:\Users\----\Documents\MiniProfiler\Sample.WebForms\web.config
LOG: Using host configuration file: C:\Windows\Microsoft.NET\Framework64\v4.0.30319\aspnet.config
LOG: Using machine configuration file from C:\Windows\Microsoft.NET\Framework64\v4.0.30319\config\machine.config.
LOG: Policy not being applied to reference at this time (private, custom, partial, or location-based assembly bind).
LOG: Attempting download of new URL file:///C:/Windows/Microsoft.NET/Framework64/v4.0.30319/Temporary ASP.NET Files/root/c7f7cc8f/aff33701/System.Data.SQLite.DLL.
LOG: Attempting download of new URL file:///C:/Windows/Microsoft.NET/Framework64/v4.0.30319/Temporary ASP.NET Files/root/c7f7cc8f/aff33701/System.Data.SQLite/System.Data.SQLite.DLL.
LOG: Attempting download of new URL file:///C:/Users/----/Documents/MiniProfiler/Sample.WebForms/bin/System.Data.SQLite.DLL.
ERR: Failed to complete setup of assembly (hr = 0x8007000b). Probing terminated.

I even added a project reference to ...MiniProfiler\packages\System.Data.SQLite.1.0.66.1\lib\System.Data.SQLite.DLL and yet I still cannot run the sample app.


#2

can you run the mvc sample app? you running on x64 or x32?


#3

x64, and now I just found a report on the web about the considerations required to be able to run an x32 on the x64 app pool. This resolved the issue.