Hello,

I tried compiling the source sqlite3-3.2.1 with the following commands on a i686 machine distro rehat linux 9 with the following commands,

./configure
make
make install

And the above process returns successful message

and all the lib* libraries are present in /usr/local/lib, i can also invoke sqlite3 by typing in the same at the prompt

I have created an application which uses GTK+-1.2 and sqlite3 , the application compiles fine without any error but while trying to execute the binary the following error surface,,

./main(This is the binary)

error while loading shared libraries: libsqlite3.so.0: cannot open shared object file: No such file or directory

as mentioned above, i have cross-checked and these libraries are present in /usr/local/lib and all have executable permissions,
The above library, libsqlite3.so.0 is linked with another library libsqlite3.so.0.8.6

But the above process works fine if i replicate them on a i386 machine with the same distro installed..

Bump

I'm having the same issue.

Need this to install and am scratching my head...

::edit:: Figured out a solutin to my problem

I simply copied the libsqlite* files from /usr/local/lib to /usr/lib & to /lib

Thank u LOLobo for the reply,,,been pondering the problem for quite some time,,,
Setting LD_LIBRARY_PATH explicitly to the path of libsqlite* also solves the problem...

But thanks to u for the alternate solution....