October 9, 2002 at 10:27 am
I've been having a lot of trouble connecting to a server. You can see the thread in the Connect forum, but after a lot of trial and error, I discovered this worked:
1. Bring up Client Network Utility.
2. Go to the Alias tab.
3. Add...
4. Make an alias Imrie. The server name defaults to Imrie. Set the Pipe Name to \\.\pipe\MSSQL$SILFW\sql\query
5. Press Apply.
6. Use Imrie to connect (not Ls-Imrie\SILFW).
The reason this works, and nothing else, is a mystery to me. But the question now is how do I make my app smart enough to use this, for the time when a DBA is not around to tend to it? The doc I've read up till now says to use the Client Network Utility, and the Server Network Utility. I want to do it programmatically. How Can this be done?
Steve
Steve Miller
October 10, 2002 at 6:21 am
You can add the net library to the connection string
Add NetworkLibrary=<library>; to the library
where <library> is one of the following
dbnmpntw - Win32 Named Pipes
dbmssocn - Win32 Winsock TCP/IP
dbmsspxn - Win32 SPX/IPX
dbmsvinn - Win32 Banyan Vines
dbmsrpcn - Win32 Multi-Protocol (Windows RPC)
Steven
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply