ADO连接数据库连接经常断开,超级频繁
浅爱 2013-07-29 04:56:19 用ADO方式连接MYSQL数据库,贴出连接数据库的代码,还望各位指点下什么情况下连接总是断开。
InitializeCriticalSection(&MysqlQuery_Lock);
HRESULT hr;
try
{
hr = m_pConnect.CreateInstance("ADODB.Connection");
if (SUCCEEDED(hr))
{
char connectStr[500];
sprintf(connectStr,"Driver=MySQL ODBC 5.1 Driver;DATABASE=%s;server=%s", sqlName, addressAndPort);
_bstr_t strConnect=connectStr;
hr = m_pConnect->Open(strConnect,userName,password,adModeUnknown);
return 0;
}
return -1;
}
catch (_com_error e)
{
Write_SrvRuning_Log(e.Description());
return -1;
}