Re: [sqlite] undefined symbol: sqlite3_prepare_v2
Joanne Pham wrote: > The question is how to check the sqlite version from this > library(libsql3.so.0.8.6. > Joanne, Have your application execute the following SQL statement and then look at the result. select sqlite_version(); This will return the versionif the library used to execute the query. HTH Dennis Cote ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] undefined symbol: sqlite3_prepare_v2
Hi All, The same problem that I had one of linux server and this server didn't have the sqlite3 So I couldn't run command sqlite3 :memory to check for the sqllite version. On this server it has only the sqlite library which is libsqlite3.so.0.8.6. The question is how to check the sqlite version from this library(libsql3.so.0.8.6. Thanks JP - Original Message From: Joanne Pham <[EMAIL PROTECTED]> To: General Discussion of SQLite Database Sent: Wednesday, February 27, 2008 10:04:36 AM Subject: Re: [sqlite] undefined symbol: sqlite3_prepare_v2 I have been using 3.5.2 sqlite. I forgot the mention this in my previous email. If you know the answer to this question please help. Thanks, JP - Original Message From: Joanne Pham <[EMAIL PROTECTED]> To: sqlite-users@sqlite.org Sent: Wednesday, February 27, 2008 9:34:05 AM Subject: [sqlite] undefined symbol: sqlite3_prepare_v2 Hi All, I used the sqlite3_prepare_v2 in my code and some of the servers are ok but one of my server return an error message that "undefined symbol: sqlite3_prepare_v2 " when the process is started and access the database using sqlite3_prepare_v2 . I don't have any clue why this problem is only happened on one single server but no others. Please help if you have an answer Thanks, JP Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] undefined symbol: sqlite3_prepare_v2
On Wed, Feb 27, 2008 at 6:23 PM, Joanne Pham <[EMAIL PROTECTED]> wrote: > Hi all, > Thx for the response! > On different Linux server. So how to find out what is the SQLite version on > the server which has the problem. > How to find out the sqlite version using Linux commnad. Doing it with a Linux command is not entirely reliable, since the Linux command could be staticly linked with a different sqlite library than the shared one your application is finding. You can try it, though: % sqlite3 :memory: sqlite> select sqlite_version(); or even: % echo "select sqlite_version();" | sqlite3 :memory: More reliable than using the command line tool (sqlite3) is to have your application issue a "SELECT sqlite_version();" and see what version is returned. Derrell ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] undefined symbol: sqlite3_prepare_v2
On Wed, Feb 27, 2008 at 6:23 PM, Joanne Pham <[EMAIL PROTECTED]> wrote: > Hi all, > Thx for the response! > On different Linux server. So how to find out what is the SQLite version on > the server which has the problem. > How to find out the sqlite version using Linux commnad. > Thanks, > JP > sqlite> select sqlite_version(); 3.4.0 sqlite> -- -- Stevie-O Real programmers use COPY CON PROGRAM.EXE ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] undefined symbol: sqlite3_prepare_v2
- Original Message From: Joanne Pham <[EMAIL PROTECTED]> To: General Discussion of SQLite Database Sent: Wednesday, February 27, 2008 3:23:09 PM Subject: Re: [sqlite] undefined symbol: sqlite3_prepare_v2 Hi all, Thx for the response! On different Linux server. So how to find out what is the SQLite version on the server which has the problem. How to find out the sqlite version using Linux commnad. Thanks, JP - Original Message From: Dimitri <[EMAIL PROTECTED]> To: General Discussion of SQLite Database Sent: Wednesday, February 27, 2008 1:54:22 PM Subject: Re: [sqlite] undefined symbol: sqlite3_prepare_v2 Hi, > I have been using 3.5.2 sqlite. I forgot the mention this in my previous > email. > If you know the answer to this question please help. sqlite3_prepare_v2 is available in SQLite 3.5.2. There must be some older version of SQLite somewhere on the single server where your code doesn't work. How is this single server different from the other servers? Different Linux distribution? Different version of SQLite? -- Dimitri ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users Looking for last minute shopping deals? Find them fast with Yahoo! Search. Never miss a thing. Make Yahoo your home page. http://www.yahoo.com/r/hs ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] undefined symbol: sqlite3_prepare_v2
Hi all, Thx for the response! On different Linux server. So how to find out what is the SQLite version on the server which has the problem. How to find out the sqlite version using Linux commnad. Thanks, JP - Original Message From: Dimitri <[EMAIL PROTECTED]> To: General Discussion of SQLite Database Sent: Wednesday, February 27, 2008 1:54:22 PM Subject: Re: [sqlite] undefined symbol: sqlite3_prepare_v2 Hi, > I have been using 3.5.2 sqlite. I forgot the mention this in my previous > email. > If you know the answer to this question please help. sqlite3_prepare_v2 is available in SQLite 3.5.2. There must be some older version of SQLite somewhere on the single server where your code doesn't work. How is this single server different from the other servers? Different Linux distribution? Different version of SQLite? -- Dimitri ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users Never miss a thing. Make Yahoo your home page. http://www.yahoo.com/r/hs ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] undefined symbol: sqlite3_prepare_v2
Hi, > I have been using 3.5.2 sqlite. I forgot the mention this in my previous > email. > If you know the answer to this question please help. sqlite3_prepare_v2 is available in SQLite 3.5.2. There must be some older version of SQLite somewhere on the single server where your code doesn't work. How is this single server different from the other servers? Different Linux distribution? Different version of SQLite? -- Dimitri ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] undefined symbol: sqlite3_prepare_v2
I have been using 3.5.2 sqlite. I forgot the mention this in my previous email. If you know the answer to this question please help. Thanks, JP - Original Message From: Joanne Pham <[EMAIL PROTECTED]> To: sqlite-users@sqlite.org Sent: Wednesday, February 27, 2008 9:34:05 AM Subject: [sqlite] undefined symbol: sqlite3_prepare_v2 Hi All, I used the sqlite3_prepare_v2 in my code and some of the servers are ok but one of my server return an error message that "undefined symbol: sqlite3_prepare_v2 " when the process is started and access the database using sqlite3_prepare_v2 . I don't have any clue why this problem is only happened on one single server but no others. Please help if you have an answer Thanks, JP Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] undefined symbol: sqlite3_prepare_v2
On Wed, Feb 27, 2008 at 12:34 PM, Joanne Pham <[EMAIL PROTECTED]> wrote: > Hi All, > I used the sqlite3_prepare_v2 in my code and some of the servers are ok > but one of my server return an error message that "undefined symbol: > sqlite3_prepare_v2 " when the process is started and access the database > using sqlite3_prepare_v2 . I don't have any clue why this problem is only > happened on one single server but no others. Please help if you have an answer It sounds like you're linking for shared library (or DLL) and the version of sqlite3 on that one system is very old: it predates the sqlite3_prepare_v2 function being added to sqlite. I believe there's an sqlite3_version() function you can call to find out what version of the library your application is finding. Derrell ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] undefined symbol: sqlite3_prepare_v2
Joanne Pham <[EMAIL PROTECTED]> wrote: > I used the sqlite3_prepare_v2 in my code and some of the servers > are ok but one of my server return an error message that "undefined > symbol: sqlite3_prepare_v2 " when the process is started and access > the database using sqlite3_prepare_v2 . I don't have any clue why > this problem is only happened on one single server but no others. That server has an older version of SQLite installed - one that doesn't yet provide sqlite3_prepare_v2 API. Igor Tandetnik ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
