Ubuntu, SQLtte3 library problem
lazarus / 1-Linux

----------------------------------------------------------------------
HappyLarry · 2016-08-15 09:06

I am trying to connect Lazarus to SQLite3 using Ubuntu 16.04. SQLite3
has been installed and works correctly in Ubuntu. The database .db
file is in the application directory. I have dropped a SQLIte3
connection component onto the form and set the database name.

However I get the error
 Can not load libsqlite3.so Check your installation.

Can someone explain simply, how to help Lazarus find this library. The
library appears to be in ./usr/lib and is called libsqlite3.so.0

----------------------------------------------------------------------
Thaddy · 2016-08-15 10:02

sudo apt-get install libsqlite3-dev

You are missing the development library.

----------------------------------------------------------------------
HappyLarry · 2016-08-15 10:17

Thanks, that solved the problem.

As a matter of interest I got the error message
QuotePackage libsqlite3-dev is not available, but is referred to by
another package.
This may mean that the package is missing, has been obsoleted, or
is only available from another source
I got it form https://launchpad.net/ubuntu/xenial/i386/libsqlite3-
dev/3.11.0-1ubuntu1 instead

----------------------------------------------------------------------
Thaddy · 2016-08-15 10:37

In that case you could have used "sudo apt-get install -f" which would
have tried to resolve the dependency.

Glad it works now  Remember: check if the dev libraries are installed
for your requirements. Often they are not, like in this case.

Oh, and libsqlite3-dev is most certainly available from the UBUNTU
repository!  I just tried...