#include <stdlib.h>
#include <stdio.h>
#include “sqlite3.h”
int main(void)
{
sqlite3 *db=NULL;
char *zErrMsg = 0;
int rc;
rc=sqlite3_open(“test1.db”,&db);
if(rc)
{
fprintf(stderr,”Can’t open database: %s\n”,sqlite3_errmsg(db));
sqlite3_close(db);
exit(1);
}
else printf(“open mydata successfully!\n”);
sqlite3_close(db);
return 0;
}
When compiling with GCC there is always an error, the compile command is as follows
gcc -static -o hello -lsqlite3 -L /usr/local/lib -I/usr/local/include hello.c
The error message is as follows
/tmp/ccKeKpX9.o(.text+0x37): In function `main’:
: undefined reference to `sqlite3_open’
/tmp/ccKeKpX9.o(.text+0x51): In function `main’:
: undefined reference to `sqlite3_errmsg’
/tmp/ccKeKpX9.o(.text+0x73): In function `main’:
: undefined reference to `sqlite3_close’
/tmp/ccKeKpX9.o(.text+0x9b): In function `main’:
: undefined reference to `sqlite3_close’
collect2: ld returned 1 exit status
The error is not in SQLITE nor in your program at all, but in GCC. the compilation parameters of Gcc are in order. The correct compile command is
gcc -o hello -L /usr/local/lib -I/usr/local/include -static hello.c -lsqlite3