ZeosDB and sqlite3

[Prime]

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]

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

[Prime]

Check 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]

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]

I 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]

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.

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]

I 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]

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.