ZeosDB and sqlite3
lazarus / 16-Databases

----------------------------------------------------------------------
Prime · 2026-04-11 20:02

Hi all,

I'm updating a program that uses ZeosDB and SQLite3.
I'm running Lazarus 4.4 on Windows 11 X64, and insalled Zeos from the
online package manager, I rebuilt the IDE without problems and removed
a couple of peroperties that where no longer in the Zeos visual
components.

However when I start up my program I get : Requested database driver
was not found.
I have the sqllite3.dll in the same folder as my executable.

Is that where it needs to be? If so how do I make Zeos use it?

Cheers.

Phill.

----------------------------------------------------------------------
Xenno · 2026-04-11 20:07

Check the dll if it is 32/64-bit version same with the app.

----------------------------------------------------------------------
Prime · 2026-04-11 20:34

Quote from: Xenno on April 11, 2026, 10:07:39 pmCheck the dll if it is
32/64-bit version same with the app.

My application is deffo 64bit, I've just recompiled it, has todays
date on the exe.
Just downloaded latest X64 sqlite3.dll and replaced the existing one,
same problem.

Cheers.

Phill.

----------------------------------------------------------------------
paweld · 2026-04-12 05:03

Is the value of the LibraryLocation property correct? For this to
work, it must be empty (in which case it will search for libraries in
the directory containing the executable file, then in the system
folder) or simply point to the correct location of the SQLite library.

----------------------------------------------------------------------
Thaddy · 2026-04-12 06:49

Quote from: Prime on April 11, 2026, 10:02:49 pmI have the
sqllite3.dll in the same folder as my executable.
sqllite3.dll ?? I guess that is a typo that is NOT in your code?
It is sqlite3.dll (single  L).

----------------------------------------------------------------------
Prime · 2026-04-12 15:57

Quote from: paweld on April 12, 2026, 07:03:11 amIs the value of the
LibraryLocation property correct? For this to work, it must be empty
(in which case it will search for libraries in the directory
containing the executable file, then in the system folder) or simply
point to the correct location of the SQLite library.

LibraryLocation is empty (I verified by printing it out to my debug
log, immediately before the connect statement for ZConnection), so
should be searching in the exe location?

Cheers.

Phill.

----------------------------------------------------------------------
Prime · 2026-04-12 15:58

Quote from: Thaddy on April 12, 2026, 08:49:46 amQuote from: Prime on
April 11, 2026, 10:02:49 pmI have the sqllite3.dll in the same folder
as my executable.
sqllite3.dll ?? I guess that is a typo that is NOT in your code?
It is sqlite3.dll (single  L).

Yes just a typo

Cheers.

Phill.

----------------------------------------------------------------------
dseligo · 2026-04-12 19:06

Make a simple test project which uses Zeos and Sqlite.
If test project doesn't work post that project here, and someone will
help you.
If test project works, problem is in your code and more debugging will
be required.