Click here to Skip to main content
15,867,308 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I am working on a winform application,it uses SQLite database.

The appliaction runs without any issue on my machine,but when i install it on other machine and try to save the data then it throws the above exception.

I have the SQLite.Interop.DLL in both my bin and debug folder of application.

I have also added the dll into application folder of setup project while deploying.

I went through the following threads but none of it helped.

What I have tried:

DLL Dependency Viewer or How To Fix Exception: “Unable to load DLL “…” The specified module could not be found. (Exception from HRESULT: 0x8007007E)”[^]



c# - Unable to load DLL 'SQLite.Interop.dll' - Stack Overflow[^]
Posted
Updated 26-Oct-20 7:08am
Comments
F-ES Sitecore 12-Jun-18 4:36am    
Is SQLite installed on the target machine? The interop dll is just a way for your .net code to interface to the underlying SQLite installation, if that installation isn't there the code has nothing to interface to.
Nishikant Tayade 12-Jun-18 4:39am    
Yes,I have installed System.Data.SQLite through package manager in my project,
and its working on my machine,but issue is when i run my setup on different machine and try to save data entered on button click.
RedDk 13-Jun-18 17:04pm    
I'm not sure this'll help you, but I've spent a few hours struggling with Nuget Package Manager on VS2010, trying to compile/link from source the SQLite netFx (1.0.108.0) with it ... and I finally succeeded at getting a referenceable System.Data.SQLite through the VS gui. Now, as for "SQLite.Interop" ... that particular .dll isn't canonically available through my "full-source" endeavor but I'd say perhaps starting from source you'll get a more local box-friendly assembly than one typically downloaded from SQLite dev site.

The caveat to my struggle was that I never managed to properly script the INSTALL which will run with a "confirm" error as-is, so my referencing was done through .NET "add" dialog. And I understand, from you're previous post, that THAT actually doesn't appear to be the issue with you because you can actually get by without an intellisense balk because you've even managed to get this "interop" to a "using" state. Which I never could, using the SQLite download of the installer pre-compiled as a binary (with a patent script switch (PS2) present apparently).
Nishikant Tayade 14-Jun-18 2:35am    
I used inno setup,as it allows you to add the dependencies on your own.So i added
all the files including SQLite.Interop.dll and it works very well.
RedDk 14-Jun-18 14:08pm    
And about that, manual referencing in the VS (to my mind what using NPM to do the dirty work, or NOT, as the case turns out to be when the VSIX is completely non compos mentis) ... it occurred to me after successful assembly inclusion that another problem might arise and that might be that the remote machine might not even have the VS runtime file (for VC++ ... even noted on the SQLite site) so be sure to include that in any installer thingmajig.

1 solution

 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900