Thread: sqlite3 library installion issue on windows

SQLite3 C interface Sample Code:

Code:

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


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


   rc = sqlite3_open("test.db", &db);


   if( rc ){
      fprintf(stderr, "Can't open database: %s\n", sqlite3_errmsg(db));
      return(0);
   }else{
      fprintf(stderr, "Opened database successfully\n");
   }
   sqlite3_close(db);
}

I have installed sqlite3 using following link:
SQLite - Installation

(I have created a folder in C: drive and placed pre-compiled binaries there along with sqlite3.h header file)

on compilation:

Code:

gcc -o sample sample.c -I C:\SQLite3
undefined reference to `sqlite3_open'
undefined reference to `sqlite3_errmsg'
undefined reference to `sqlite3_close'
collect2.exe: error: ld returned 1 exit status

So my question is how to install sqlite3 library in windows correctly?

Any help will be appreciated. Thank you.