高手指点:VC6连接SQL SRV,如何设置超时时间啊?
ffww 2010-12-07 05:19:46 try
{
HRESULT hr=m_pConnection.CreateInstance(__uuidof(Connection));
m_pConnection->CursorLocation=adUseClient;
CString strSQL="Provider=SQLOLEDB.1;Persist Security Info=True;User ID=sa;Password=adminadmin;Initial Catalog=LocalDataAnalyticalSystem;Data Source=10.36.65.232";
m_pConnection->TimeOut=5; // 放在这里不管用啊
if(SUCCEEDED(hr))
{
hr=m_pConnection->Open(_bstr_t(strSQL),"","",-1);
}
}
catch(_com_error e)///捕捉异常
{
return;
}
连接SQL服务器,如果该服务器停止了服务,我不想连那么长时间.
资料上说把TimeOut放在OPen前就行了,我试了下,不行啊,还是超时50秒左右