RT出错时间不定,有时候一天出现几次,有时候好多天才出现一次连接字符串:Provider=OraOLEDB.Oracle.1; User ID=callcenter;Password=123;Data Source=shark曾尝试在连接字符串中加上:Pooling=false;好像仍然没有解决问题,请各位大侠帮忙,在此先谢啦。在线等~~~~~~~
出错处:MySet->Open("select * from interface where record_state=0",MyDB.GetInterfacePtr(),adOpenForwardOnly,adLockOptimistic,adCmdText);错误描述:ORA-03114:未连接上ORALCEORACLE 9i和ORACLE 10G上都会出现这个问题
{
if (m_strService.IsEmpty())
{
::MessageBox(NULL,"·þÎñÃû²»ÄÜΪ¿Õ","Ìáʾ",MB_OK);
return FALSE;
} theApp.m_pConnection.CreateInstance(__uuidof(Connection));
try
{
//OLEDBÇý¶¯
theApp.m_strDatabase=m_strService;
CString strConn;
strConn="Provider=OraOLEDB.Oracle.1;Password=";
strConn+=m_strPassword;
strConn+=";Persist Security Info=True;User ID=";
strConn+=m_strUsername;
// strConn+=";SERVER=";
// strConn+=m_strService;
strConn+=";Data Source=";
strConn+= m_strService;
theApp.m_pConnection->Open((_bstr_t)strConn,
"",
"",
adModeUnknown);
}
catch(_com_error e)
{
::MessageBox(NULL,e.Description(),"Ìáʾ",MB_OK);
return FALSE;
}
::MessageBox(NULL,"Êý¾Ý¿âÁ¬½Ó³É¹¦£¡","Ìáʾ",MB_OK);
return TRUE;}
在建立数据库连接是没有问题的,如下:
if(InitMyDB())
{
if(MyDB->State)
{
if(FAILED(MySet.CreateInstance("ADODB.Recordset")))
{
WriteLog("Create MySet Instance Failed!");
MyDB->Close();
return false;
}
MySet->Open(_variant_t("select * from interface where record_state=0"),MyDB.GetInterfacePtr(),adOpenForwardOnly,adLockOptimistic,adCmdText);
//MySet->MoveFirst();
}
}InitMyDB()实现对数据库连接对象MyDB的初始化及OPEN操作,顺利通过,而在MySet->Open()时出现错误,更奇怪的是错误无法预计什么时间会发生,请指教