Problems With SQLite

New to SQLite. Copied a program from a tutorial site to test whether it is working or not!

Code:

#include <iostream>
#include <sqlite3.h>
#include <stdlib.h>

// g++ AccessTableEmployee.cpp -lsqlite3

using namespace std;

static int callback(void *NotUsed, int argc, char **argv, char **azColName)
{
  int i;
  cout << "Number of args= " << argc << endl;

  for(i=0; i<argc; i++)
  {
     cout << azColName[i] << " = " << (argv[i] ? argv[i] : "NULL") << endl;
  }
  cout << endl;
  return 0;
}

int main(int argc, char **argv)
{
  sqlite3 *db;       // Declare pointer to sqlite database structure
  char *zErrMsg = 0;

  // Open Database 

  int rc = sqlite3_open("Try.db", &db);
  if( rc )
  {
    cerr << "Can't open database: " << sqlite3_errmsg(db) << endl;
    sqlite3_close(db);
    exit(1);
  }
  // Select from database 

  rc = sqlite3_exec(db,"select * from emp", callback, 0, &zErrMsg);
  if( rc!=SQLITE_OK )
  {
      cerr << "SQL error: " << zErrMsg << endl;
      sqlite3_free(zErrMsg);
  }

  // Close

  sqlite3_close(db);
  return 0;
}

compiled using following command

g++ -o SQL SQLite.cpp

I am getting following error

/tmp/ccxSqt2x.o: In function `main':
SQLTry.cpp: (.text+0xfd): undefined reference to `sqlite3_open'
SQLTry.cpp: (.text+0x114): undefined reference to `sqlite3_errmsg'
SQLTry.cpp: (.text+0x152): undefined reference to `sqlite3_close'
SQLTry.cpp: (.text+0x18a): undefined reference to `sqlite3_exec'
SQLTry.cpp: (.text+0x1d5): undefined reference to `sqlite3_free'
SQLTry.cpp: (.text+0x1e1): undefined reference to `sqlite3_close'
collect2: ld returned 1 exit status

googled for the solution and came across the same solution every where in the from of following command

g++ -o SQL -lsqlite3 SQLite.cpp

But this solution is not working with me!
Any Help Appreciated!

Using GCC on Debian Linux...

Have you tried linking to the library sqlite3 as your Google results show?

The command you used

Code:

g++ -o SQL SQLite.cpp

The normal way to link to the library

Code:

g++ -o SQL SQLite.cpp -lsqlite3

Tim S.

Urgh
I am soooooo silly!

Thank You A Lot!