Interacting with SQL databases from a win32 client

Hey everyone, I've been trying to make my application fire inserts to a mysql database and have been having a pretty hard time, I've tried to use the connector from mysql's website but so far its seems quite poor as my application crashes everytime i try and fire an insert.

Could anyone show me an example of how this can be done on win32 using just the header files in visual c++?

What makes you think any example we produce will be any better than any example you've seen already.

Maybe you should post YOUR code, so we can see what you're really doing, as opposed to what we might imagine you're doing.

Code:

---

                Param * p = static_cast<Param *>(Parameters);
                string Achievement = p->Achievement;
                string DBName = p->DBName;
                string Hostname = p->Hostname;
                string Password = p->Password;
                string Username = p->Username;

            string playername = GetUsername();

                string query = "INSERT INTO tblUser (user_name, user_password) VALUES ('" + Username + "', '" + Password + "')";

                sql::mysql::MySQL_Driver *driver;
                sql::Connection        *con;
                sql::Statement        *stmt;

        //Will typically crash on this line
                driver = sql::mysql::get_mysql_driver_instance();
                con = driver->connect(Hostname, Username, Password);

                stmt = con->createStatement();
        //Or this line
                stmt->execute("USE projectdb;");
                stmt->execute(query);

                delete stmt;
                delete con;

                cout << "Send insert finished!" << endl;

---

This is the code I've been using with MySQL Connector/C++. Even inside a try catch block this will still crash the application

> driver = sql::mysql::get_mysql_driver_instance();
Well you don't check for success.
So if it fails, most likely driver is NULL, and the very next line is up the creek without the paddle.

Use a debugger, and put a breakpoint on that line. Then single step and examine your input variables to make sure all is as you expect.

Also, does the C++ interface to MySQL accept std::string parameters?