User Rating!

Home > Search > Knowledge Base > SQL Server > Articles

FIX: SQL Server Driver Fails to Connect over TCP/IP Using Three Parameters in Address Keyword (Q311836)

Total Hits: 2112  |  Today: 0       Rating:

Read Reviews | Write Review | Your Rating:  Select One 5 Stars - Best Rating 4 Stars 3 Stars 2 Stars 1 Star - Worst Rating

A connection to a back-end SQL Server database may fail with the following error:[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen (Connect()).[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied. This error occurs under the following conditions: You are using the Microsoft ODBC Driver for SQL Server 2000 that comes with Microsoft Data Access Components (MDAC) version 2.6, 2.6 SP1, 2.6 SP2, or 2.7. The TCP/IP protocol is used; in other words, the Network keyword is set to DBMSSOCN. The Address keyword contains three parameters; for example, the server name or IP address, the port number, and an urgent token: "DSN=DSNName;SERVER=servername;DATABASE=pubs;Network=DBMSSOCN;Address=IP_Address,1433,urgent;" The server to which you are connecting is not a local server.

DevASP.Net users Rating What is your opinion? 5 Stars4 Stars3 Stars2 Stars1 Star

Is this your listing?

If this is your listing and you like to add the rating box
displayed on the right side on your site you can use the following code.