all groups > sql server odbc > october 2004 >
You're in the

sql server odbc

group:

name pipe VS tcpip



name pipe VS tcpip !
10/6/2004 9:49:30 AM
sql server odbc: I found that I can only use name pipe to connect to the sql server.
When I use tcpip, it fails to connect.
I am sure I have enabled the TCP/IP protocol in SQL server
What causes it?

sql is using port no.1433 and I have try using dynamically determine port
and force it to 1433 in ODBC setting.

thank you very much

Re: name pipe VS tcpip Steve Thompson
10/7/2004 10:03:24 AM
[quoted text, click to view]

There are a lot of reasons that this can fail, application type being one of
them. Reference the following as a troubleshooting guide:
http://support.microsoft.com/default.aspx?scid=kb;en-us;827422

Steve

AddThis Social Bookmark Button