sql server odbc: ODBC Port -- sql server odbc

ODBC Port

Adam Sankey
3/29/2007 7:24:02 AM

sql server odbc:

Hi, I have just installed a default instance of SQL server 2000 and can
connect ok with Query Analyser. I can connect ok with ODBC via a DSN if I
don't specify the port. However if I specify the port (which is 1433 I've
double checked) in the DSN or a JDBC connection it fails! Can somebody help
me?

Thanks

Re: ODBC Port

Bindesh Vijayan[MSFT]
4/20/2007 4:26:07 AM

on the sql serve box :
check the programs->sqlserver2000>sql server network utilitity
click tcp and check properties
you should be able to see the port configured, if tcp is enabled

thanks

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server odbc group.