[SOLVED]Can't load SQLite client library

[bubu42]

Hello,
That's been quite a long time since I last used Lazarus (actually over 8 years, on Windows XP).
Now, I'm trying to build a new application, using SQLite3 on Ubuntu (Linux). Things seem to quite different from Win XP !
I've installed SQLite3 on my machine, but when I try to Connect the TSQLite component I get the error message : Cannot load SQLite3 library (libsqlite3.so). Check your installation.
I've copied the libsqlite3.so file from /usr/lib/i386-linuxgnu into my application folder, but it doesn't seem to help.
What am I doing wrong ? Any advice welcome !
Thanks in advance.

[kapibara]

You just need to install the package libsqlite3-dev in Ubuntu.
Remove the .so file that you copied manually.

[MarkMLl]

You just need to install the package libsqlite3-dev in Ubuntu.
Remove the .so file that you copied manually.

Detail: the -dev package sets up a symlink that the normal package omits.

I'm not sure, but https://wiki.freepascal.org/TSQLDBLibraryLoader might be relevant as an alternative, but I've not done any heavyweight database-related development since it was added (before that, I either installed the -dev package where needed or did my own library search).

I must say that having to install a development package on an end-user's system is a very unsatisfactory situation. However this is fundamentally a Debian issue (inherited by Ubuntu), rather than a Lazarus/LCL/FPC one.

MarkMLl

[Zvoni]

Don't forget 32-Bit vs. 64-Bit
i see a "i386..." above

[MarkMLl]

Don't forget 32-Bit vs. 64-Bit
i see a "i386..." above

I saw that as well, but since he provided the entire source path and didn't say that he'd moved it between systems decided to give him the benefit of the doubt...

I've not got any significant SQLite stuff on the system in front of me, but I do note

Code: Text  [Select][+][-]

1. ~$ locate libsqlite3.so
2. /usr/lib/x86_64-linux-gnu/libsqlite3.so.0
3. /usr/lib/x86_64-linux-gnu/libsqlite3.so.0.8.6
4.  

For the purpose of comparison, the fairly complete PostgreSQL installation (i.e. explicitly including the -dev package) has

Code: Text  [Select][+][-]

1. ~$ locate libpq.so
2. /usr/lib/x86_64-linux-gnu/libpq.so -> libpq.so.5.11
3. /usr/lib/x86_64-linux-gnu/libpq.so.5 -> libpq.so.5.11
4. /usr/lib/x86_64-linux-gnu/libpq.so.5.11
5.  

... and an app looking for either libpq.so or libpq.so.5 will be sent to the actual library file libpq.so.5.11

MarkMLl

[bubu42]

Thanks a lot, folks ! That did it.
Actually, the 32/64 bits thing was the origin. I also checked the symlink.