SQL Server Performance Forum – Threads Archive

TCP/IP and Named Pipes connection string

I have a Connection string which is used to connect to a SQL SERVER Database Server from ASP page. Connection string 1: Provider=SQLOLEDB.1;Network Liberary=dbmssocn<img src=’/community/emoticons/emotion-4.gif’ alt=’;P’ />ersist Security Info=False;User ID=sa; Initial Catalog=Center;Data Source=20.145.112.112 I want to user a simple query string with named pipe and not with the Network Liberary=dbmssocn option as below: Connection string 2: Provider=SQLOLEDB.1<img src=’/community/emoticons/emotion-4.gif’ alt=’;P’ />ersist Security Info=False;User ID=sa; Initial Catalog=Center;Data Source=20.145.112.112 If i use the "Connection string 2" it says "SQL Server not found" Can some one suggest on how can i connect the SQL server using the "Connection string 2" connection string. Server Information Web server is Windows 2000 ,SP 5 Database server is SQL Server 2000 mdac Level is 2.80.1022.3

You posted a similar question in another post. This has to do with your default network library. If you do not want to specify the "network library=" option then change your default network library with cliconfg.exe. You can override the default setting in your connectionstring with "network library=". Valid options are:
dbnmpntw – Named Pipes
dbmssocn – Winsock TCP/IP
dbmsspxn – SPX/IPX
dbmsvinn – Banyan Vines
dbmsrpcn – Multi-Protocol (Windows RPC)

]]>