Method 2: Update System Install all patches for Windows Vista. There are about 20 threads running concurrently, each of them connects to a same database in a remote SQL Server, the related information is: Code = 80004005 Code meaning = Unspecified error Source = Provider and this error is induced by follow code: CString csConnectionString( " Provider=sqloledb Server=remote SQL Server DataBase=some DB UID=user PWD=pwd " ) _ConnectionPtr m_pConn _CommandPtr m_pCmd HRESULT hr m_pConn.CreateInstance(_T("ADODB.Connection")) m_pCmd.CreateInstance(_T("ADODB.Command")) m_pConn->ConnectionTimeout = 10 _bstr_t bstrSRC( csConnectionString ) hr = m_pConn->Open(bstrSRC,_T(""),_T(""),-1) // _com_error exception thrown I have tried following methods to solve my problem: Method 1: Change Connection String Using ODBC instead of OLE DB, the connection string is modified as: Driver=SQL Server Server=remote SQL Server DataBase=some DB UID=user PWD=pwd However, another error occurs: Code = 80004005, Code meaning = Unspecified error, Source = Microsoft OLE DB Provider for ODBC Drivers, Description = communication links fail I've done a lot of search but find no clues. The connection string I used is " Provider=sqloledb Server=remote SQL Server DataBase=some DB UID=user PWD=pwd ". The SQL Server is MS SQL Server 2005 Enterprise Edition with SP3. At client side, the programming language is C++, and client OS is Windows Vista Business 32-bit, with Windows DAC 6.0, version.
I'm connecting to SQL Server 2005 via ADO OLE DB.
0 kommentar(er)
