ODBC problem

[rgao]

Hi there
I'm facing the problem of ODBC.the computer using winxp os can using ODBC connect with my SQL serve(sql2000).other computer using win2k can not set up ODBC to connect with this SQL server.the SQL server is same,the seting of ODBC is same,the only difference of these ODBC is:in winxp ODBC we use tcp/ip and dynamically get port number.but in win2k
no Dynamically get port number option,we use tcp/ip port 1433, but it failed.port number make problem?Does some one have experience about it?

Thanks for any hints
Thanks in advance
rgao

 

[chester27]

try using port 1434