Unable to load DLL SQLite.Interop.dll on some windows 10 pcs despite existing in the correct folder

Unity Engine
1

We have built a windows 10 application which utilizes the SQLite system to manage a database of users following this tutorial:

Everything works perfect in the editor and build on my PC and a select few other PCs.

However, we have a few laptops and PC’s in the office for which it does not work. The application is copied in its entirety from the working directory on my PC but we get this error when the application is trying to load the DLL on the other PC (either on app load or when trying to access the database, we have tried both):

Fallback handler could not load library C:/Users/Administrator/Desktop/APPLICATION DIRECTORY/APPLICATION DIRECTORY_Data/Mono/SQLite.Interop.dll

We have tried copying the DLL to this location (usually not necessary, as copying it to the application’s exe folder works on the working machine/s), as well as trying the usual plugins folder and the Managed folder. Unfortunately none of these locations work.

We have tried all the usual suspects, including copying the whole SQLite dll package to the Mono folder, but nothing will make it work.

We wonder if a Windows System DLL is missing on the machines that wont work, but we cannot identify the issues.

Any help would be greatly appreciated.

2

By chance are the non-working machines 32 bit and the working machines 64 bit?

3

Unfortunately not (I do wish that it was this simple!). All are 64bit and also have windows 10 pro installed.

EDIT: I also have tried a 32bit build anyway with the correct 32bit dll and still no luck

4

Nudging this because it is still an issue and we still haven’t found a solution! Please help

5

A database of users? Where does the database live? Generally SQLite is used locally, for a single user. Granted it doesn’t answer your question, but just curious what you’re using SQLite for.

6

Sorry if I necro this, but did you ever find a solution? I’m experiencing the same problem right now.