Lib LNK2001 why?

[juanmanuelsanchez]

hi all ! Im trying to compile a project and everything works fine, now Im adding a new lib for handling a database. I got the files from http://www.sqlite.org/

all Im trying to do is this :

#include "sqlite3.h" //DB

Player::LoadPlayerDataDB()
{
  #pragma comment (lib, "lib/sqlite.lib") /* link with Microsoft OpenGL lib */
 sqlite3 *db;
 char *zErrMsg = 0;
 int rc;
 const char *sqlite3_libversion(void);

  const char *filename="/Database/player.db";

  rc = sqlite3_open(filename, &db);
  if( rc ){
    sqlite3_close(db);
    exit(1);
  }

But I get the link error, the thing is that I ave worked with Libs before and I actually use some atm and I had no probs, I added the lib to my project and all but still have the same error.

Any help is appreciated.

THanks!