Does anyone have any experience using MySQL++? It's a wrapper for MySQL commands for use in C++. I can't seem to get them to work on my Ubuntu 6.06 box. Are there any tricks to setting them up? I used apt-get and it claims they are installed, but my program can't seem to find the libraries during compile time. My first thought was that the correct directories were not being included, but I double checked the locations and they have the mysql.h files and the libraries. Any help or comments would be appreciated.

i'm assumming you're using g++ or something. You want to add the flags:



so if your library is libmysql.so and it's in /usr/local/lib, you'll want to add



Also dont forget to add the proper -I flags to help find the .h files

If you're just farting around with 'pure' SQL, you might want to look into SQLite.

I know Red Hat is retarded in that you could have the lib<whatever> package installed but when you go to include code from it, the compiler complains. What you really needed was the lib<whatever>-dev package. I've run into this a couple of times with Ubuntu as well. So try

apt-cache search (name of library)

and see if there's a (name of library)-dev package, then

apt-get install (name of library)-dev

or whatever to get that one.


Why you would install a lib package and not want to include/link to it escapes me, but that's what they do.

Thanks for the tips, but the program still won't compile. Using sqlite or something like that isn't an option, as I am using code that was given to me for a project. My actual error now during compile time is an undefined reference to mysqlpp::Connection::Connection(bool), when I am attempting to create an object that could connect to the database. I checked and I have the -dev packages. Everything should be calling correctly since I am am trying to compile a test program based on the example from the mysql++ website.

1) Double / Triple check paths and the -l. ( I.e. -lmysqlpp)
2) I believe that the order the libraries are listed in is significant.
I.e. if you have: -llibMyLib -lm -lthread -lmysqlpp
linking may fail, but it might work with: -lmysqlpp -llibMyLib -lm -lthread

http://docs.hp.com/en/B2355-90655/ch02s06.html



Bill