Re: [sqlite] error compilation with Sqlite in C program
Ow! I'm stupid it's sqlite3 not sqlite
Thank you to all for your help
-Message d'origine-
De : sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
De la part de Robert Myers
Envoyé : jeudi 12 avril 2012 18:15
À : sqlite-users@sqlite.org
Objet : Re: [sqlite] error compilation with Sqlite in C program
On 4/12/2012 11:07 AM, Sako Youssouf wrote:
> Here my step and the result.
>
> # gcc -c sqlite3.c
> # ar -rvs libsqlite3.a sqlite3.o
> ar: creating libsqlite3.a
> a - sqlite3.o
>
> # gcc -L. -lsqlite -L/usr/lib/ -ldl -lpthread -o compil compil.c
Here's your problem. You want -lsqlite3
> /tmp/ccfdSnPR.o: In function `main':
> compil.c:(.text+0xc3): undefined reference to `sqlite3_open'
> compil.c:(.text+0xda): undefined reference to `sqlite3_errmsg'
> compil.c:(.text+0x101): undefined reference to `sqlite3_close'
> compil.c:(.text+0x138): undefined reference to `sqlite3_exec'
> compil.c:(.text+0x16d): undefined reference to `sqlite3_free'
> compil.c:(.text+0x179): undefined reference to `sqlite3_close'
> collect2: ld a retourné 1 code d'état d'exécution
>
> compil.c :
>
> 01 #include
> 02 #include
> 03
> 04 static int callback(void *NotUsed, int argc, char **argv, char
> **azColName){
> 05int i;
> 06for(i=0; i<argc; i++){
> 07 printf("%s = %s\n", azColName[i], argv[i] ? argv[i] : "NULL");
> 08}
> 09printf("\n");
> 10return 0;
> 11 }
> 12
> 13 int main(int argc, char **argv){
> 14sqlite3 *db;
> 15char *zErrMsg = 0;
> 16int rc;
> 17
> 18if( argc!=3 ){
> 19 fprintf(stderr, "Usage: %s DATABASE SQL-STATEMENT\n", argv[0]);
> 20 return(1);
> 21}
> 22rc = sqlite3_open(argv[1],);
> 23if( rc ){
> 24 fprintf(stderr, "Can't open database: %s\n", sqlite3_errmsg(db));
> 25 sqlite3_close(db);
> 26 return(1);
> 27}
> 28rc = sqlite3_exec(db, argv[2], callback, 0,);
> 29if( rc!=SQLITE_OK ){
> 30 fprintf(stderr, "SQL error: %s\n", zErrMsg);
> 31 sqlite3_free(zErrMsg);
> 32}
> 33sqlite3_close(db);
> 34return 0;
> 35 }
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] error compilation with Sqlite in C program
On Thu, Apr 12, 2012 at 6:07 PM, Sako Youssouf < youssouf.s...@renault-trucks.com> wrote: > # ar -rvs libsqlite3.a sqlite3.o > # gcc -L. -lsqlite -L/usr/lib/ -ldl -lpthread -o compil compil.c > You're back to the first problem you had: linking against /usr/lib/libsqlite.* -- - stephan beal http://wanderinghorse.net/home/stephan/ http://gplus.to/sgbeal ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] error compilation with Sqlite in C program
On 4/12/2012 11:07 AM, Sako Youssouf wrote:
Here my step and the result.
# gcc -c sqlite3.c
# ar -rvs libsqlite3.a sqlite3.o
ar: creating libsqlite3.a
a - sqlite3.o
# gcc -L. -lsqlite -L/usr/lib/ -ldl -lpthread -o compil compil.c
Here's your problem. You want -lsqlite3
/tmp/ccfdSnPR.o: In function `main':
compil.c:(.text+0xc3): undefined reference to `sqlite3_open'
compil.c:(.text+0xda): undefined reference to `sqlite3_errmsg'
compil.c:(.text+0x101): undefined reference to `sqlite3_close'
compil.c:(.text+0x138): undefined reference to `sqlite3_exec'
compil.c:(.text+0x16d): undefined reference to `sqlite3_free'
compil.c:(.text+0x179): undefined reference to `sqlite3_close'
collect2: ld a retourné 1 code d'état d'exécution
compil.c :
01 #include
02 #include
03
04 static int callback(void *NotUsed, int argc, char **argv, char **azColName){
05int i;
06for(i=0; i
Re: [sqlite] error compilation with Sqlite in C program
Here my step and the result.
# gcc -c sqlite3.c
# ar -rvs libsqlite3.a sqlite3.o
ar: creating libsqlite3.a
a - sqlite3.o
# gcc -L. -lsqlite -L/usr/lib/ -ldl -lpthread -o compil compil.c
/tmp/ccfdSnPR.o: In function `main':
compil.c:(.text+0xc3): undefined reference to `sqlite3_open'
compil.c:(.text+0xda): undefined reference to `sqlite3_errmsg'
compil.c:(.text+0x101): undefined reference to `sqlite3_close'
compil.c:(.text+0x138): undefined reference to `sqlite3_exec'
compil.c:(.text+0x16d): undefined reference to `sqlite3_free'
compil.c:(.text+0x179): undefined reference to `sqlite3_close'
collect2: ld a retourné 1 code d'état d'exécution
compil.c :
01 #include
02 #include
03
04 static int callback(void *NotUsed, int argc, char **argv, char **azColName){
05int i;
06for(i=0; i
Re: [sqlite] error compilation with Sqlite in C program
I just tested this and at least on RedHat 5 the index on the library (ranlib or
"s") doesn't make a difference.
You must be doing something wrong so please show your complete steps.
This works for me:
cc -c sqlite3.o
ar rvs libsqlite3.a sqlite3.o
cc -o mytest mytest.c -L. -lsqlite3 -lpthread -ldl
mytest.c:
#include
#include
#include
#include "sqlite3.h"
int main()
{
sqlite3 *db;
sqlite3_stmt *stmt;
int status;
char *create = "create table test(a integer);";
status=sqlite3_open_v2("test.db",,SQLITE_OPEN_READWRITE|SQLITE_OPEN_CREATE,NULL);
if (status != SQLITE_OK) {
printf("open error:%s\n",sqlite3_errmsg(db));
exit(1);
}
sqlite3_exec(db,create,NULL,NULL,NULL);
return 0;
}
Michael D. Black
Senior Scientist
Advanced Analytics Directorate
Advanced GEOINT Solutions Operating Unit
Northrop Grumman Information Systems
From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on
behalf of Sako Youssouf [youssouf.s...@renault-trucks.com]
Sent: Thursday, April 12, 2012 10:31 AM
To: General Discussion of SQLite Database
Subject: EXT :Re: [sqlite] error compilation with Sqlite in C program
Michael I rebuild library and after I done the "ranlib" step but the same error
occur!
Stephan I tried the change that you propose but the same error occur!
Others ideas?
-Message d'origine-
De : sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
De la part de Black, Michael (IS)
Envoyé : jeudi 12 avril 2012 17:17
À : General Discussion of SQLite Database
Objet : Re: [sqlite] error compilation with Sqlite in C program
You're missing a step in your library build.
ranlib libsqlite.a
Michael D. Black
Senior Scientist
Advanced Analytics Directorate
Advanced GEOINT Solutions Operating Unit
Northrop Grumman Information Systems
From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on
behalf of Sako Youssouf [youssouf.s...@renault-trucks.com]
Sent: Thursday, April 12, 2012 10:10 AM
To: General Discussion of SQLite Database
Subject: EXT :Re: [sqlite] error compilation with Sqlite in C program
Yes that what I tried but as you can see below when I do that, the first error
reappear.
root@ubuntu:/home/y_sako/Documents/sqlite-amalgamation-3071100# ar -rv
libsqlite.a sqlite3.o
ar: creating libsqlite.a
a - sqlite3.o
root@ubuntu:/home/y_sako/Documents/sqlite-amalgamation-3071100# gcc
-L/home/y_sako/Documents/sqlite-amalgamation-3071100/ -lsqlite -L/usr/lib/ -ldl
-lpthread -o compil compil.c
/tmp/cc7IDdvz.o: In function `main':
compil.c:(.text+0xc3): undefined reference to `sqlite3_open'
compil.c:(.text+0xda): undefined reference to `sqlite3_errmsg'
compil.c:(.text+0x101): undefined reference to `sqlite3_close'
compil.c:(.text+0x138): undefined reference to `sqlite3_exec'
compil.c:(.text+0x16d): undefined reference to `sqlite3_free'
compil.c:(.text+0x179): undefined reference to `sqlite3_close'
collect2: ld a retourné 1 code d'état d'exécution
-Message d'origine-
De : sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
De la part de Stephan Beal
Envoyé : jeudi 12 avril 2012 17:06
À : General Discussion of SQLite Database
Objet : Re: [sqlite] error compilation with Sqlite in C program
On Thu, Apr 12, 2012 at 5:00 PM, Sako Youssouf <
youssouf.s...@renault-trucks.com> wrote:
> compil.c:(.text+0x6f): multiple definition of `main'
>
Remove shell.o from your libsqlite.a.
--
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] error compilation with Sqlite in C program
Same error with -s argument with or without the shell.o in the archive. there have it other way to use Sqlite in a C program ? -Message d'origine- De : sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] De la part de Stephan Beal Envoyé : jeudi 12 avril 2012 17:33 À : General Discussion of SQLite Database Objet : Re: [sqlite] error compilation with Sqlite in C program On Thu, Apr 12, 2012 at 5:31 PM, Sako Youssouf < youssouf.s...@renault-trucks.com> wrote: > Others ideas? > Can you paste in the last thing (or two) you tried? You might also try passing -s to ar (it's equivalent to calling ranlib, from what i understand). -- - stephan beal http://wanderinghorse.net/home/stephan/ http://gplus.to/sgbeal ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] error compilation with Sqlite in C program
On Thu, Apr 12, 2012 at 5:31 PM, Sako Youssouf < youssouf.s...@renault-trucks.com> wrote: > Others ideas? > Can you paste in the last thing (or two) you tried? You might also try passing -s to ar (it's equivalent to calling ranlib, from what i understand). -- - stephan beal http://wanderinghorse.net/home/stephan/ http://gplus.to/sgbeal ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] error compilation with Sqlite in C program
Michael I rebuild library and after I done the "ranlib" step but the same error occur! Stephan I tried the change that you propose but the same error occur! Others ideas? -Message d'origine- De : sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] De la part de Black, Michael (IS) Envoyé : jeudi 12 avril 2012 17:17 À : General Discussion of SQLite Database Objet : Re: [sqlite] error compilation with Sqlite in C program You're missing a step in your library build. ranlib libsqlite.a Michael D. Black Senior Scientist Advanced Analytics Directorate Advanced GEOINT Solutions Operating Unit Northrop Grumman Information Systems From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Sako Youssouf [youssouf.s...@renault-trucks.com] Sent: Thursday, April 12, 2012 10:10 AM To: General Discussion of SQLite Database Subject: EXT :Re: [sqlite] error compilation with Sqlite in C program Yes that what I tried but as you can see below when I do that, the first error reappear. root@ubuntu:/home/y_sako/Documents/sqlite-amalgamation-3071100# ar -rv libsqlite.a sqlite3.o ar: creating libsqlite.a a - sqlite3.o root@ubuntu:/home/y_sako/Documents/sqlite-amalgamation-3071100# gcc -L/home/y_sako/Documents/sqlite-amalgamation-3071100/ -lsqlite -L/usr/lib/ -ldl -lpthread -o compil compil.c /tmp/cc7IDdvz.o: In function `main': compil.c:(.text+0xc3): undefined reference to `sqlite3_open' compil.c:(.text+0xda): undefined reference to `sqlite3_errmsg' compil.c:(.text+0x101): undefined reference to `sqlite3_close' compil.c:(.text+0x138): undefined reference to `sqlite3_exec' compil.c:(.text+0x16d): undefined reference to `sqlite3_free' compil.c:(.text+0x179): undefined reference to `sqlite3_close' collect2: ld a retourné 1 code d'état d'exécution -Message d'origine- De : sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] De la part de Stephan Beal Envoyé : jeudi 12 avril 2012 17:06 À : General Discussion of SQLite Database Objet : Re: [sqlite] error compilation with Sqlite in C program On Thu, Apr 12, 2012 at 5:00 PM, Sako Youssouf < youssouf.s...@renault-trucks.com> wrote: > compil.c:(.text+0x6f): multiple definition of `main' > Remove shell.o from your libsqlite.a. -- - stephan beal http://wanderinghorse.net/home/stephan/ http://gplus.to/sgbeal ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] error compilation with Sqlite in C program
On Thu, Apr 12, 2012 at 5:10 PM, Sako Youssouf < youssouf.s...@renault-trucks.com> wrote: > root@ubuntu:/home/y_sako/Documents/sqlite-amalgamation-3071100# gcc > -L/home/y_sako/Documents/sqlite-amalgamation-3071100/ -lsqlite -L/usr/lib/ > -ldl -lpthread -o compil compil.c > what happens if you replace -l... -L... with sqlite3.o? -- - stephan beal http://wanderinghorse.net/home/stephan/ http://gplus.to/sgbeal ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] error compilation with Sqlite in C program
You're missing a step in your library build. ranlib libsqlite.a Michael D. Black Senior Scientist Advanced Analytics Directorate Advanced GEOINT Solutions Operating Unit Northrop Grumman Information Systems From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Sako Youssouf [youssouf.s...@renault-trucks.com] Sent: Thursday, April 12, 2012 10:10 AM To: General Discussion of SQLite Database Subject: EXT :Re: [sqlite] error compilation with Sqlite in C program Yes that what I tried but as you can see below when I do that, the first error reappear. root@ubuntu:/home/y_sako/Documents/sqlite-amalgamation-3071100# ar -rv libsqlite.a sqlite3.o ar: creating libsqlite.a a - sqlite3.o root@ubuntu:/home/y_sako/Documents/sqlite-amalgamation-3071100# gcc -L/home/y_sako/Documents/sqlite-amalgamation-3071100/ -lsqlite -L/usr/lib/ -ldl -lpthread -o compil compil.c /tmp/cc7IDdvz.o: In function `main': compil.c:(.text+0xc3): undefined reference to `sqlite3_open' compil.c:(.text+0xda): undefined reference to `sqlite3_errmsg' compil.c:(.text+0x101): undefined reference to `sqlite3_close' compil.c:(.text+0x138): undefined reference to `sqlite3_exec' compil.c:(.text+0x16d): undefined reference to `sqlite3_free' compil.c:(.text+0x179): undefined reference to `sqlite3_close' collect2: ld a retourné 1 code d'état d'exécution -Message d'origine- De : sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] De la part de Stephan Beal Envoyé : jeudi 12 avril 2012 17:06 À : General Discussion of SQLite Database Objet : Re: [sqlite] error compilation with Sqlite in C program On Thu, Apr 12, 2012 at 5:00 PM, Sako Youssouf < youssouf.s...@renault-trucks.com> wrote: > compil.c:(.text+0x6f): multiple definition of `main' > Remove shell.o from your libsqlite.a. -- - stephan beal http://wanderinghorse.net/home/stephan/ http://gplus.to/sgbeal ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] error compilation with Sqlite in C program
Yes that what I tried but as you can see below when I do that, the first error reappear. root@ubuntu:/home/y_sako/Documents/sqlite-amalgamation-3071100# ar -rv libsqlite.a sqlite3.o ar: creating libsqlite.a a - sqlite3.o root@ubuntu:/home/y_sako/Documents/sqlite-amalgamation-3071100# gcc -L/home/y_sako/Documents/sqlite-amalgamation-3071100/ -lsqlite -L/usr/lib/ -ldl -lpthread -o compil compil.c /tmp/cc7IDdvz.o: In function `main': compil.c:(.text+0xc3): undefined reference to `sqlite3_open' compil.c:(.text+0xda): undefined reference to `sqlite3_errmsg' compil.c:(.text+0x101): undefined reference to `sqlite3_close' compil.c:(.text+0x138): undefined reference to `sqlite3_exec' compil.c:(.text+0x16d): undefined reference to `sqlite3_free' compil.c:(.text+0x179): undefined reference to `sqlite3_close' collect2: ld a retourné 1 code d'état d'exécution -Message d'origine- De : sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] De la part de Stephan Beal Envoyé : jeudi 12 avril 2012 17:06 À : General Discussion of SQLite Database Objet : Re: [sqlite] error compilation with Sqlite in C program On Thu, Apr 12, 2012 at 5:00 PM, Sako Youssouf < youssouf.s...@renault-trucks.com> wrote: > compil.c:(.text+0x6f): multiple definition of `main' > Remove shell.o from your libsqlite.a. -- - stephan beal http://wanderinghorse.net/home/stephan/ http://gplus.to/sgbeal ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] error compilation with Sqlite in C program
On Thu, Apr 12, 2012 at 5:00 PM, Sako Youssouf < youssouf.s...@renault-trucks.com> wrote: > compil.c:(.text+0x6f): multiple definition of `main' > Remove shell.o from your libsqlite.a. -- - stephan beal http://wanderinghorse.net/home/stephan/ http://gplus.to/sgbeal ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] error compilation with Sqlite in C program
Thank you for your answer Stephan I tried to adding -L command apparently it solved the problem but another error occur. root@ubuntu:/home/y_sako/Documents/sqlite-amalgamation-3071100# gcc -L/home/y_sako/Documents/sqlite-amalgamation-3071100/ -lsqlite -L/usr/lib/ -ldl -lpthread -o compil compil.c /tmp/cccbS6DV.o: In function `main': compil.c:(.text+0x6f): multiple definition of `main' /home/y_sako/Documents/sqlite-amalgamation-3071100//libsqlite.a(shell.o):shell.c:(.text+0x7515): first defined here collect2: ld a retourné 1 code d'état d'exécution I tried to add just the sqlite.c file in the library and recompile and there the first problem is comeback. root@ubuntu:/home/y_sako/Documents/sqlite-amalgamation-3071100# ar -rv libsqlite.a sqlite3.o ar: creating libsqlite.a a - sqlite3.o root@ubuntu:/home/y_sako/Documents/sqlite-amalgamation-3071100# gcc -L/home/y_sako/Documents/sqlite-amalgamation-3071100/ -lsqlite -L/usr/lib/ -ldl -lpthread -o compil compil.c /tmp/cc7IDdvz.o: In function `main': compil.c:(.text+0xc3): undefined reference to `sqlite3_open' compil.c:(.text+0xda): undefined reference to `sqlite3_errmsg' compil.c:(.text+0x101): undefined reference to `sqlite3_close' compil.c:(.text+0x138): undefined reference to `sqlite3_exec' compil.c:(.text+0x16d): undefined reference to `sqlite3_free' compil.c:(.text+0x179): undefined reference to `sqlite3_close' collect2: ld a retourné 1 code d'état d'exécution do you see what I have to changed? -Message d'origine- De : sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] De la part de Stephan Beal Envoyé : jeudi 12 avril 2012 16:18 À : General Discussion of SQLite Database Objet : Re: [sqlite] error compilation with Sqlite in C program On Thu, Apr 12, 2012 at 4:14 PM, Sako Youssouf < youssouf.s...@renault-trucks.com> wrote: > root@ubuntu:/home/y_sako/Documents/sqlite-amalgamation-3071100# gcc > -lsqlite -o compil compil.c > Are you sure your -lsqlite isn't picking up an sqlite2 under /usr/lib? Could you try adding -L. to your compile command? -- - stephan beal http://wanderinghorse.net/home/stephan/ http://gplus.to/sgbeal ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] error compilation with Sqlite in C program
On Thu, Apr 12, 2012 at 4:14 PM, Sako Youssouf < youssouf.s...@renault-trucks.com> wrote: > root@ubuntu:/home/y_sako/Documents/sqlite-amalgamation-3071100# gcc > -lsqlite -o compil compil.c > Are you sure your -lsqlite isn't picking up an sqlite2 under /usr/lib? Could you try adding -L. to your compile command? -- - stephan beal http://wanderinghorse.net/home/stephan/ http://gplus.to/sgbeal ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] error compilation with Sqlite in C program
Hi, I'm a new user of sqlite, i want to test utilization of sqlite in a C program. So I generated a static lib of sqlite (using the amalgamation files) and I try to use it in my C program. But I get some error. Below my compilation code and the return error. The program that I wanted test is the C program on this page : http://www.sqlite.org/quickstart.html root@ubuntu:/home/y_sako/Documents/sqlite-amalgamation-3071100# gcc -c shell.c root@ubuntu:/home/y_sako/Documents/sqlite-amalgamation-3071100# gcc -c sqlite3.c root@ubuntu:/home/y_sako/Documents/sqlite-amalgamation-3071100# ar -rv libsqlite.a shell.o sqlite3.o ar: creating libsqlite.a a - shell.o a - sqlite3.o root@ubuntu:/home/y_sako/Documents/sqlite-amalgamation-3071100# gcc -lsqlite -o compil compil.c /tmp/ccBIvSMw.o: In function `main': compil.c:(.text+0xc3): undefined reference to `sqlite3_open' compil.c:(.text+0xda): undefined reference to `sqlite3_errmsg' compil.c:(.text+0x101): undefined reference to `sqlite3_close' compil.c:(.text+0x138): undefined reference to `sqlite3_exec' compil.c:(.text+0x16d): undefined reference to `sqlite3_free' compil.c:(.text+0x179): undefined reference to `sqlite3_close' collect2: ld a retourné 1 code d'état d'exécution can someone explain me what is the problem ? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
