mysql 静态 vc_vc++2013中使用MySQL connector/C++ 1.1.4静态链接报错

包含头文件

#include

#include

#include

#include

#include

#ifdef _DEBUG

#pragma comment(lib, "mysqlcppconn.lib")

#else

#pragma comment(lib, "mysqlcppconn-static.lib")

// 我的MySQL connector/C++是自己下源码编译的,需要引入这个,官方直接提供的二进制我不清楚需要不需要

#pragma comment(lib, "mysqlclient.lib")

#endif

代码

try

{

const char* user = "root";

const char* passwd = "";

const char* host = "tcp://192.168.1.8:3306";

const char* database = "mysql";

sql::mysql::MySQL_Driver* driver = sql::mysql::get_driver_instance();

sql::Connection* conn = driver->connect(host, user, passwd);

conn->setSchema(database);

sql::Statement *stmt = conn->createStatement();

sql::ResultSet *res = stmt->executeQuery("select * from user;");

while (res->next()) {

AfxMessageBox((res->getString() + " | " + res->getString()).c_str());

}

delete res;

delete stmt;

delete conn;

}

catch (sql::SQLException e) {

CString strErrorMsg;

strErrorMsg.Format("MySQL error code %d: %s, %s", e.getErrorCode(), e.what(),