Lazarus

Programming => Databases => Topic started by: Kalevi on October 28, 2019, 10:38:46 am

Title: Cannot load SQLite client library "sqlite3.dll"
Post by: Kalevi on October 28, 2019, 10:38:46 am

When I try connected TSQLite3Connection appears message "Cannot load SQLite client library "sqlite3.dll" , Check your installation"
I need that connect when I use LazReport the elements.

Title: Re: Cannot load SQLite client library "sqlite3.dll"
Post by: RayoGlauco on October 28, 2019, 11:44:55 am

Maybe you need to include these lines somewhere in your code:

Code: Pascal [Select][+]

uses sqlite3dyn; 
// ...
sqlite3dyn.SQLiteDefaultLibrary := path_to_sqlite3dll;

Where path_to_sqlite3dll is the path where sqlite3.dll is.

Title: Re: Cannot load SQLite client library "sqlite3.dll"
Post by: avra on October 28, 2019, 12:21:10 pm

Put sqlite3.dll in some global dir already in %PATH%, or put it in the directory of your Lazarus.exe.

Title: Re: Cannot load SQLite client library "sqlite3.dll"
Post by: Kalevi on October 28, 2019, 01:06:13 pm

I have the sqlite3.dll in every directors. I use Lazarus IDE v2.0.4 . Is there a way how I can use the LazReport elements?

Title: Re: Cannot load SQLite client library "sqlite3.dll"
Post by: rvk on October 28, 2019, 01:45:15 pm

Quote from: Kalevi on October 28, 2019, 01:06:13 pm

I have the sqlite3.dll in every directors. I use Lazarus IDE v2.0.4 . Is there a way how I can use the LazReport elements?

Are you using the 64 bit Lazarus or the 32 bit one?
You need to match the bitness of the sqlite3.dll with Lazarus.

Title: Re: Cannot load SQLite client library "sqlite3.dll"
Post by: Kalevi on October 28, 2019, 02:20:18 pm

I using the 64 bit Lazarus, isnt these sqlite3.dll different ?

Title: Re: Cannot load SQLite client library "sqlite3.dll"
Post by: rvk on October 28, 2019, 02:50:54 pm

Quote from: Kalevi on October 28, 2019, 02:20:18 pm

I using the 64 bit Lazarus, isnt these sqlite3.dll different ?

Then you need the 64 bit version of sqlite3.dll.
I don't know where you got it and if it clearly stated it was the 64 bit version?

Title: Re: Cannot load SQLite client library "sqlite3.dll"
Post by: Kalevi on October 28, 2019, 02:56:04 pm

Ok, Thanks
Im change to 32 bit version.

Title: Re: Cannot load SQLite client library "sqlite3.dll"
Post by: rvk on October 28, 2019, 02:57:41 pm

Quote from: Kalevi on October 28, 2019, 02:56:04 pm

Ok, Thanks
Im change to 32 bit version.

It's easier to take the sqlite3.dll 64 bit version than to reinstall Lazarus 32 bit entirely.

Just make sure you take the "64-bit DLL (x64) for SQLite version 3.30.1" version from this page:
https://www.sqlite.org/download.html