This is actually answered on the system.data.sqlite download page. https://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki
Scroll down to the section, "Using Native Library Pre-Loading". For some reason (?) on Chrome the text is about 30pt, so you shouldn't be able to miss it. Essentially, it says to have the DLLs in the right directory, underneath the application. <bin>\App.exe (optional, managed-only application executable assembly) <bin>\App.dll (optional, managed-only application library assembly) <bin>\System.Data.SQLite.dll (required, managed-only core assembly) <bin>\System.Data.SQLite.Linq.dll (optional, managed-only LINQ assembly) <bin>\System.Data.SQLite.EF6.dll (optional, managed-only EF6 assembly) <bin>\x86\SQLite.Interop.dll (required, x86 native interop assembly) <bin>\x64\SQLite.Interop.dll (required, x64 native interop assembly) Some SQL command you're firing off requires the use of the DLL, and some of your clients are set up correctly (or have that DLL on their system) while others don't. Its an easy fix. Thanks, Chris On Thu, Jul 6, 2017 at 1:55 PM, Paul Sanderson <[email protected] > wrote: > Could your 32 bit app be picking up a 64 bit dll. Could you rename the > dll's and hard code the location into your library? > > May not work for your release code but may help you narrow down the issue. > > Paul > > > On Wed, 5 Jul 2017 at 18:19, Simon Slavin <[email protected]> wrote: > > > > > > > On 5 Jul 2017, at 1:41pm, Gregor Pavuna <[email protected]> wrote: > > > > > As it seems there's some sort of server problem(Windows 2012 server). > My > > guess is server is caching 64bit files and serving them to 32bit > operating > > systems. I tested on my test server with laptop (32bit windows 7) and it > > works fine. Than i went to client and connected laptop there and it > didn't > > work with their files. > > > > You are keeping your application on a server ? Or a library ? Does the > > problem go away if you keep your application and libraries on the client > > computer instead ? > > > > > I also googled that out, but couldn't find anything on that topic. Any > > suggestions? > > > > Whatever the problem, it seems that it’s related to the Windows > > application loading system, not SQLite. So you might find another forum > is > > able to help you better than this one. > > > > Simon. > > _______________________________________________ > > sqlite-users mailing list > > [email protected] > > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > -- > Paul > www.sandersonforensics.com > skype: r3scue193 > twitter: @sandersonforens > Tel +44 (0)1326 572786 > http://sandersonforensics.com/forum/content.php?195-SQLite- > Forensic-Toolkit > -Forensic Toolkit for SQLite > email from a work address for a fully functional demo licence > _______________________________________________ > sqlite-users mailing list > [email protected] > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
