sqlite.dll placement in windows
lazarus / 16-Databases

----------------------------------------------------------------------
davesimplewear · 2009-11-12 01:15

I have installed lazarus in windows xp and installed sqlite3 but
lazarus won't start, the message is that the sqlite.dll can't be
found, i have placed the dll in windows system folder but it still
won't load, its been along time since I used windows and have
forgotten where this goes, could someone help please.

----------------------------------------------------------------------
Zaher · 2009-11-12 15:42

First Place Sqlite beside lazarus.exe

----------------------------------------------------------------------
davesimplewear · 2009-11-12 23:44

I put the sqlite3.dll in lazarus directory and got the same result,
put it in sqlite folder in components sub-directory, same result.

----------------------------------------------------------------------
mrmikehicks · 2009-11-14 05:31

I think the dll for sqlite3 is sqlite3.dll not sqlite.dll. Just a
thought.

----------------------------------------------------------------------
TurboRascal · 2009-11-20 16:15

Quote from: mrmikehicks on November 14, 2009, 06:31:54 amI think the
dll for sqlite3 is sqlite3.dll not sqlite.dll. Just a thought.

You're correct. The right dll IS "sqlite3.dll" and everything should
work fine if it's put to system32 dir when sqlite3 package is
installed.

However, it seems strange if you really installed sqlite3 package, why
would it ask for "sqlite.dll" - sqlite3 package complains that it
cannot find "sqlite3.dll". Did you really install version 3, not 2? Or
did you perhaps misread the error dialog?

----------------------------------------------------------------------
lijinjie · 2021-03-24 07:14

I had the same problem .. I copied the sqlite3.dll to the lazaurs
folder, but it still asks for sqlite.dll. I tried to change its name
to sqlite.dll couldn't work either.

----------------------------------------------------------------------
af0815 · 2021-03-24 07:49

First the bitness must be correct with lazarus. In 32bit Lazarus you
can only use 32bit dll. 64Bit Lazarus need a 64 bit dll.
Second you have to place the second dll in the same folder like your
executable is, this version must have the bitness of your app !!!

Rename works, if the version and bitness is ok. Attention, often it is
not clear what bittness you have in the dll, because the naming have
no schema.

BTW: For the App you are able to change the path of the dll (and so
for linux as well) by code. It is possible for zeos and SQLdb, but
implemented in a differnet way.