已经成功连接,并能操作,但在一段时间没操作的时候,再进行操作时出错,检查连接状态仍然是打开的,但就是不能操作,重新连接后,问题就消失了.会不会是空闲时间大长,它就会自动断开呢?Set m_CN = New ADODB.Connection
m_CN.CursorLocation = adUseClient
m_CN.ConnectionString = "Provider=OraOLEDB.Oracle.1;Password=" & m_gPWD & ";Persist Security Info=True;User ID=" & m_gUID & ";Data Source=" & m_gDSN
m_CN.Open执行这一句的时候出错,
m_adors.Open sSQL1, m_CN, adOpenDynamic, adLockPessimistic, 1错误代码: 实时错误. '-2147217900(80040e14) ORA-03114: ?????ORACLE.
m_CN.CursorLocation = adUseClient
m_CN.ConnectionString = "Provider=OraOLEDB.Oracle.1;Password=" & m_gPWD & ";Persist Security Info=True;User ID=" & m_gUID & ";Data Source=" & m_gDSN
m_CN.Open执行这一句的时候出错,
m_adors.Open sSQL1, m_CN, adOpenDynamic, adLockPessimistic, 1错误代码: 实时错误. '-2147217900(80040e14) ORA-03114: ?????ORACLE.
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货