PRB: ODBC Connection Failed: SQLState: '08001' DBMSSOCNID: Q195566
|
The following error message is returned from the ODBC Data Source Administrator and/or an ODBC application while attempting to make a connection to SQL Server:
Connection failed:
SQLState: '08001'
SQL Server Error: 11
[Microsoft][ODBC SQL Server Driver][DBMSSOCN] General Network error. Check your documentation.
Connection failed:
SQLState: '01000'
SQL Server Error: 10061
[Microsoft][ODBC SQL Server Driver][DBMSSOCN]ConnectionOpen(connect())
The most common reason that this connection attempt failed is that this DSN or ODBC data source attempted to make a connection using the TCP/IP sockets Net-Library, which is Dbmssocn.dll. Because the SQL Server is not listening for incoming connections for TCP/IP sockets clients, the connection fails. From ISQL/w, the second error message stated above would be returned. The OS Error is 10061, and the function call that failed was ConnectionOpen(connect()).
By default, SQL Server will listen for incoming connections made by Named
Pipes clients. Named Pipes is the default IPC mechanism for clients to
connect to a SQL Server version 4.2, 6.0, and 6.5 server. The Named Pipes
DLL is Dbnmpntw.dll, and it should be located in the Windows\System or
Winnt\System32 directory. The most common resolution to this problem is to
configure the client computer to connect using Named Pipes.
This topic is also discussed in a troubleshooter available at the following
location:
http://support.microsoft.com/support/tshoot/tshooterlist.asp?PR=sql
Additional query words: Win95 datasource open database connectivity netlib lib net SBS Small Business Server
Keywords : SSrvGen SSrvNet_Lib SSrvVisB
Version : winnt:6.5
Platform : winnt
Issue type : kbprb
Last Reviewed: April 10, 1999