Share Button

When you try to connect ODBC application to the SQL server then sometimes you might have received driver error. You get this driver error message due to the missing of Dbmssocn.dll file. Dbmssocn.dll file in system is used to make connection using TCP/IP sockets Net- library and the main reason for occurring this error is that when you try to make connection to the SQL server by using ODBC driver then it happens that the connection gets failed which is done by using TCP/IP sockets net-Library which is known as Dbmssocn.dll and should be located in Windows\System or Winnt\System32 directory. This because the SQL server is not paying attention to the incoming connections for the TCP/IP sockets and in this condition, connection tends to fail and you receive the OS error 10061.

What are the symptoms?

When you try to make a connection to the SQL server from the ODBC data source administrator then sometimes the connection fails and return you the following error message:-

“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())”

“Connection failed:
SQLState: 08001
SQL Server Error: 11
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]General network error. Check your network documentation.”

“Connection failed:
SQLState: 01000
SQL Server Error: 10061
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen (connect())”

How to fix this ODBC driver error?

SQL server by default is listening for incoming connections which is done by Named Pipes clients. Named Pipes clients is the default IPC mechanism which is used by the clients to make connections for the SQL Server version 4.2, 6.0, and 6.5 servers. Named Pipes dll is also known as Dbnmpntw.dll and its proper location is Windows\System or Winnt\System32 directory. You can resolve this error by constructing the client computer to connect by using Named pipes. And to construct the client start the Create New Data Source wizard and then click on the client configuration button and then work on the given below steps for the SQL server ODBC application version 3.50:-

1. Select and click the Net Library tab and to set the default network in the Named Pipes, click the drop down list box.
2. Remove the advanced entries from the advanced tab and then click on done option.
3. If you are using SQL Server ODBC application version 3.70 the follow the given below steps:-
4. From the Edit Network Library Configuration dialog box, click on Network libraries and from there select the named pipes option and then click ok.

If you don’t have MDAC ODBC driver installed in your system then use the third party repair tool to set the default Net- Library to the Named pipes. Third party repair tool will not only fix this driver error but also set the Net- Library to the Named pipes.

Share Button
Fix driver error “ODBC Connection Failed: SQLState: ‘08001’ DBMSSOCN”

Leave a Reply

Your email address will not be published. Required fields are marked *