Search - Articles
DevASP.NET for ASP.NET, VB.NET, XML and C# (C-Sharp) Developers Sunday, December 17, 2017

Dev Articles
Search Directory
SQL Server

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: 2173  |  Today: 0       Rating:  
Read Reviews | Write Review | Your 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.

What's New at DevASP.Net
04/23  A Debug Stopwatch
04/23  The virtual bool bug
04/23  Application.EnableVisualStyles Bu..
04/23  The Process Async Reader Bug
04/23  Load a DBF into a DataTable
04/23  Weird Error: Unable to Validate D..
04/23  ASP.NET and jQuery to the Max
04/23  Fixing Error: "SetConfigurationSe..
04/23  Generics in .NET
04/23  Builder Design Pattern
04/23  Abstract Factory Design Pattern
04/23  Prototype Design Pattern
04/23  Bridge Design Pattern
04/23  Composite Design Pattern
04/23  Decorator Design Pattern
04/23  Validation in .NET Framework 4
04/23  Windows Phone 7: How to Encrypt C..
04/23  Text box to accept only number
04/23  Using the Raw Input API to Proces..
04/23  Study EVM (Earned Value Managemen..

DevASP.Net - Disclaimer - Privacy