Re: [Mingw-users] Installing SQLite

[<ti...@sc...>]

Tuomo Latto wrote:
> Maybe you should ask on sqlite mailing list?
> After reading your post more carefully, I see your final problem is
> linker errors. Maybe if you posted some details, people might actually
> be able to help you.
>
>
>   
I dont't think that details of the error will help somebody finding the 
problem. For me it seems that mingw simply can't do anything with the 
libsqlite3.a file. Anyway here are the errors:

 >gcc -lsqlite3 test.c -o test
C:\DOKUME~1\Timo\LOKALE~1\Temp/ccKoaaaa.o:test.c:(.text+0xfa): undefined 
reference to `sqlite3_open'
C:\DOKUME~1\Timo\LOKALE~1\Temp/ccKoaaaa.o:test.c:(.text+0x10e): 
undefined reference to `sqlite3_errmsg'
C:\DOKUME~1\Timo\LOKALE~1\Temp/ccKoaaaa.o:test.c:(.text+0x135): 
undefined reference to `sqlite3_close'
C:\DOKUME~1\Timo\LOKALE~1\Temp/ccKoaaaa.o:test.c:(.text+0x16f): 
undefined reference to `sqlite3_exec'
C:\DOKUME~1\Timo\LOKALE~1\Temp/ccKoaaaa.o:test.c:(.text+0x1a2): 
undefined reference to `sqlite3_free'
C:\DOKUME~1\Timo\LOKALE~1\Temp/ccKoaaaa.o:test.c:(.text+0x1ad): 
undefined reference to `sqlite3_close'
collect2: ld returned 1 exit status

Here is the test.c test-programm:

#include <stdio.h>
#include <sqlite3.h>
#include <unistd.h>

static int callback(void *NotUsed, int argc, char **argv, char **azColName){
  int i;
  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_free(zErrMsg);
  }
  sqlite3_close(db);
  return 0;
}



sqlite3.h is in <mingw>/include/ and libsqlite3.a and sqlite3.dll is in 
<mingw>/lib/


But maybe I really should ask in the sqlite maling list.