Thread: MinGW and SQLite

Hi I am a seasoned C# developer trying to learn Objective-C using MinGW.

I have a working install of Objective-C and am trying to work with SQLite.
I have the SQLite3.dll in C:\windows\system32 (on the path), sqlite3.h in the include directoy (C:\MinGW\include) and libsqlite3.a in the lib directory (c:\MinGW\lib).

When I try to compile

#include <stdio.h>
#include <stdlib.h>
#include "sqlite3.h"

static int callback(void *NotUsed, int argc, char **argv, char **azColName){
int i;
NotUsed=0;

for(i=0; i<argc; i++){
printf("%s = %s\n", azColName[i], argv[i] ? argv[i] : "NULL");
}
printf("\n");
return 0;
}

int main(int argc, char **argv){
sqlite3 *db;
char *zErrMsg = 0;
int rc;

if( argc!=3 ){
fprintf(stderr, "Usage: %s DATABASE SQL-STATEMENT\n", argv[0]);
exit(1);
}
rc = sqlite3_open(argv[1], &db);
if( rc ){
fprintf(stderr, "Can't open database: %s\n", sqlite3_errmsg(db));
sqlite3_close(db);
exit(1);
}
rc = sqlite3_exec(db, argv[2], callback, 0, &zErrMsg);
if( rc!=SQLITE_OK ){
fprintf(stderr, "SQL error: %s\n", zErrMsg);
}
sqlite3_close(db);
return 0;
}

simply with gcc sqltest.c -o sqltest, I get the error "undefined reference to 'sqlite3_open'"

It is picking up the header as it recognises the sqlite type.

Do I need to specify linking in the library or should it just pick it up from the default lib directory?

Any help is greatly appreciated as I seem to be missing something fundamental.

Thanks in advance.

Carl

See an absolute newbie.

I needed to specify -lsqlite3 simple as.

Originally Posted by nadroj

You likely have to specify that you're linking to the library. Look around in the documentation for the API, it may be something like "-lsqlite3" that you have to pass to gcc.

EDIT: I see you got it.

I found it in the end but appreciate you taking the time to respond, thanks.

You're quite welcome.