DllNotFoundException: sqlite3 on Unity 2020.1.17

[joncl84]

Hi

I just downloaded SimpleSQL today.

I get the error stated at the subject when trying to create a table from a class, inside an editor mode script.

I already saw the FAQ sections on dll not found, and they all apply to android and older Unity versions, and mostly occur on compilation. I haven't even compiled yet.

I'm running Unity on Windows 10 and I am aiming to PC as well.

I already tried changing in options from one system to other and back, and nothing happened.

The sqlite3.dll link in the FAQ was broken, and since I just downloaded the asset today, I would expect it to have the latest version in it.

Further detail:

SimpleSQL.SQLiteConnection..ctor (System.String databasePath) (at <207fc23201404c1f986749afb0ece901>:0)
SimpleSQL.SimpleSQLManager.CreateConnection (System.String documentsPath) (at <207fc23201404c1f986749afb0ece901>:0)
SimpleSQL.SimpleSQLManager.Initialize (System.Boolean forceReinitialization) (at <207fc23201404c1f986749afb0ece901>:0)
SimpleSQL.SimpleSQLManager.CreateTable[T] () (at <207fc23201404c1f986749afb0ece901>:0)
Common.Tester.CreateTable () (at Assets/0-Project/Scripts/Testing/Tester.cs:53)

[echo17]

Sorry about the broken link. That FAQ was for a very old version of Unity (Unity 5). I've updated it just in case anyone else tries to click on it.

So the sqlite library that comes with SimpleSQL is packaged so that when you build your project it will extract the library for you at compiled runtime (not in the Editor, in other words). If you are getting missing dll errors in your Editor, that means that your operating system does not have sqlite by default. Most do, which is why that is so odd. Try going to this link: sqlite.org (Precompiled binaries for Windows) to download the sqlite library for your OS and architecture. You'll need to place the sqlite3.dll in your project's root folder. If that does not work, try the Assets folder.

This is a one-off situation that I've only had two people report on Windows in eight years. I'm not sure what about your Windows setup is missing sqlite, but hopefully this will help you out.