After installing the Fedora Core 2 zlib dev package I was able to successfully compile mysql++.

I still went ahead and added the two new path entries to the ld.so.conf file and executed ldconfig.

Encouraged, I tried to compile my dbtest.cpp test program but still encountered many errors. I have not been able to determine what is going on even though I have tried for most of the day. Unfortunately, in this case, my forte` is windows development and not linux development. I may have screwed something up (versioning etc) while I was trying to staisfy all the rpm dependencies. This machine was not originally setup for development so I had to load gcc and everything it depended on.

I am simply trying to use some of the sample code to connect to my local database and execute a select query. The code is below:

#include <iostream> #include <iomanip> #include <mysql++.h>

using namespace mysqlpp; using namespace std;

int main() { Connection con("test","localhost","test","test"); // The full format for the Connection constructor is // Connection(cchar *db, cchar *host="", // cchar *user="", cchar *passwd="") // You may need to specify some of them if the database is not on // the local machine or you database username is not the same as your // login name, etc..

Query query = con.query(); // This creates a query object that is bound to con.

query << "SELECT * FROM monitor"; // You can write to the query object like you would any other ostrem

Result res = query.store(); // Query::store() executes the query and returns the results

cout << "Query: " << query.preview() << endl; // Query::preview() simply returns a string with the current query // string in it.

cout << "Records Found: " << res.size() << endl << endl;

Row row; cout.setf(ios::left); cout << setw(10) << "monitor_id" << setw(1) << "monitor_type" << setw(50) << "monitor_title" << setw(4) << "monitor_status" << setw(4) << "monitor_email" << setw(10) << "monitor_day_ttl" << setw(10) << "monitor_week_ttl" << setw(10) << "monitor_month_ttl" << endl;

Result::iterator i; // The Result class has a read-only Random Access Iterator for (i = res.begin(); i != res.end(); i++) { row = *i; cout << setw(10) << row["monitor_id"] << setw(10) << row["monitor_type"] << setw(50) << row["monitor_title"] << setw(4) << row["monitor_status"] << setw(4) << row["monitor_email"] << setw(10) << row["monitor_day_ttl"] << setw(10) << row["monitor_week_ttl"] << setw(10) << row["monitor_month_ttl"] << endl; } return 0; }

The errors I am getting are shown below:

[root@localhost temp]# g++ -o dbtest dbtest.cpp /tmp/ccIwAWIf.o(.text+0x35): In function `main': : undefined reference to `mysqlpp::Connection::Connection[in-charge](char const*, char const*, char const*, char const*, bool)' /tmp/ccIwAWIf.o(.text+0x4e): In function `main': : undefined reference to `mysqlpp::Connection::query()' /tmp/ccIwAWIf.o(.text+0x700): In function `main': : undefined reference to `mysqlpp::Connection::~Connection [in-charge]()' /tmp/ccIwAWIf.o(.text+0x79f): In function `main': : undefined reference to `mysqlpp::Connection::~Connection [in-charge]()' /tmp/ccIwAWIf.o(.gnu.linkonce.t._ZN7mysqlpp3RowC1Ev+0x2c): In function `mysqlpp::Row::Row[in-charge]()': : undefined reference to `vtable for mysqlpp::Row' /tmp/ccIwAWIf.o(.gnu.linkonce.t._ZN7mysqlpp3RowC1Ev+0x38): In function `mysqlpp::Row::Row[in-charge]()': : undefined reference to `vtable for mysqlpp::Row' /tmp/ccIwAWIf.o(.gnu.linkonce.t._ZN7mysqlpp3RowD1Ev+0xc): In function `mysqlpp::Row::~Row [in-charge]()': : undefined reference to `vtable for mysqlpp::Row' /tmp/ccIwAWIf.o(.gnu.linkonce.t._ZN7mysqlpp3RowD1Ev+0x18): In function `mysqlpp::Row::~Row [in-charge]()': : undefined reference to `vtable for mysqlpp::Row' /tmp/ccIwAWIf.o(.gnu.linkonce.t._ZN7mysqlpp6ResultD1Ev+0x1a): In function `mysqlpp::Result::~Result [in-charge]()': : undefined reference to `mysqlpp::ResUse::~ResUse [not-in-charge]()' /tmp/ccIwAWIf.o(.gnu.linkonce.t._ZN7mysqlpp5Query7previewEv+0x1b): In function `mysqlpp::Query::preview()': : undefined reference to `mysqlpp::SQLQuery::str(mysqlpp::SQLQueryParms&)'

I believe mysql++ will be perfect for what I am trying to do so any assistance getting this code up and running would really be appreciated.