I tried with the last version but I still have the same problems. I'm not sure that the appropriated version of sqlite API is used in my application, because I have the following message when I run sudo make install :
PATH="$PATH:/sbin" ldconfig -n /usr/local/lib ---------------------------------------------------------------------- Libraries have been installed in: /usr/local/lib If you ever happen to want to link against installed libraries in a given directory, LIBDIR, you must either use libtool, and specify the full pathname of the library, or use the `-LLIBDIR' flag during linking and do at least one of the following: - add LIBDIR to the `LD_LIBRARY_PATH' environment variable during execution - add LIBDIR to the `LD_RUN_PATH' environment variable during linking - use the `-Wl,--rpath -Wl,LIBDIR' linker flag See any operating system documentation about shared libraries for more information, such as the ld(1) and ld.so(8) manual pages. ---------------------------------------------------------------------- Do you think I should set an LD_LIBRARY_PATH environment variable ? -----Message d'origine----- De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Envoyé : jeudi 13 juillet 2006 13:48 À : sqlite-users@sqlite.org Objet : Re: [sqlite] Using Sqlite 3.2.1 on linux "zze-ContentLab MARTINEAU Y ext RD-SIRP-REN" <[EMAIL PROTECTED]> wrote: > Here is what I have been told regarding the application: > > "A newer version of sqlite3-dev ( > 3.2.1) would not work. This > problem = is due to SQL requests threading. Newer versions force user > to open a = new connection for each Thread. We did not take the time > to adapt our = code." > They have that backwards. Older versions do not allow database connections to be passed across threads due to bugs in Linux. There is a work-around for that bug beginning in version 3.3.1. You should use the latest release. -- D. Richard Hipp <[EMAIL PROTECTED]>