I need to connect to a MySQL database using a C++ CGI. I've tried using mysql++ but I keep getting errors during compile. The only time I got it to work was when I used the Visual Studio project file that was included, but I prefer to stay away from Visual Studio. Using a different compiler, I get errors stating that there is a syntax error on the line that calls Connection, even though there isn't. Or I get an error stating that Socket is used an object.
I need someone to provide me with sample code that actually compiles, and tell me exactly what libs/header files to include.
I am using Bloodshed Dev C++, but am able to switch if there is a better compiler out there.