vc++连接MYSQL数据库出现问题
把mysql-connector-c++-1.1.0-win32装上了,但是在连接MYSQL数据库时到m_pCon = m_pDriver->connect( strHostName, struserName, strPassword);这一语句还是报错,参数变量的值都对,这有可能是哪方面的原因呢
[解决办法]
m_strHost = "tcp://127.0.0.1:3306"; m_strUser = "root"; m_strPassword = "123456"; m_pDriver = get_driver_instance(); if ( !m_pDriver ) { return DBUnit_Fail_GetInstance; } //连接数据库并读取信息 Statement *pState = NULL; ResultSet *pResult = NULL; Connection* pConnect = NULL; try { pConnect = m_pDriver->connect(m_strHost, m_strUser, m_strPassword); pState = pConnect->createStatement(); pState->execute("use im_datacenter"); char szSql[1024]={0}; sprintf(szSql,"SELECT * FROM im_datacenter.tb_userinfo where id = %d and passwd='%s'",info.nUserId,info.cPasswd); pResult = pState->executeQuery(szSql); int nRet = pResult->rowsCount(); if ( nRet == 1) { SAFE_DELETE(pResult); SAFE_DELETE(pState); SAFE_DELETE(pConnect); return DBUnit_Succeed; } else { printf("not find user!\n"); SAFE_DELETE(pResult); SAFE_DELETE(pState); SAFE_DELETE(pConnect); return 1; } } catch (...) { SAFE_DELETE(pState); SAFE_DELETE(pResult); SAFE_DELETE(pConnect); printf("db exception!!!why?\n"); return DBUnit_Exception_GetSecondSrvStreamInfo; }