Sqlite3 and C++

[kardon33]

I am trying to just do a test of sqlite3 and C++ but I having touble.

I am compiling on Mac OS X.


Program:
<code>

#include <iostream>
using namespace std;

#include <sqlite3.h>
sqlite3* db;
char* db_err;

int main() {
sqlite3_open("testDB.sql", &db);
sqlite3_exec(db, "create table 'helloworld' (id integer);", NULL, 0, &db_err);
sqlite3_close(db);
}
</code>



Output:

**** Build of configuration Debug for project HelloWorld ****

make all
Building file: ../src/HelloWorld.cpp
Invoking: GCC C++ Compiler
g++ -O0 -g3 -Wall -c -fmessage-length=0 -MMD -MP -MF"src/HelloWorld.d" -MT"src/HelloWorld.d" -o"src/HelloWorld.o" "../src/HelloWorld.cpp"
Finished building: ../src/HelloWorld.cpp

Building target: HelloWorld
Invoking: MacOS X C++ Linker
g++ -o "HelloWorld" ./src/HelloWorld.o
Undefined symbols:
"_sqlite3_open", referenced from:
_main in HelloWorld.o
"_sqlite3_close", referenced from:
_main in HelloWorld.o
"_sqlite3_exec", referenced from:
_main in HelloWorld.o
ld: symbol(s) not found
collect2: ld returned 1 exit status
make: *** [HelloWorld] Error 1

[JosAH]

There must be a sqllite3 library somewhere; feed that to your linker in the last stage of the build; check your manuals how to do that.

kind regards,

Jos

[RedSon]

There is no library for SQLite if you are using the SQLite amalgamation file. You must add SQLite.c to your build so that the symbols are created properly. Your linker is complaining that it doesnt know what "_sqlite3_open", "_sqlite3_exec" and "_sqlite3_close" mean.

[kardon33]

Thanks all, I did get it working. I switched to a new IDE and thought they were linked but it wasnt.

[tvnaidu]

Can I compile sqlite3 calls with C code and run on Redhat Linux machine?. thanks.

[RedSon]

The source code is available for free. You should be able to answer that question for yourself.