Can't connect SQL server through ODBC -- sql server odbc

Ling
9/15/2003 3:51:29 AM

Hi,

I created a System DSN under Data Source (ODBC). However,
if I had input the machine name instead of ip address,
then it wasn't run proper. Prompt the message
Connection failed: SQLState:
'HYT00' SQL Server Error: 0
[Microsoft][ODBC SQL Server Driver]Timeout expired

I have ping the machine name and was OK.

Sue Hoegemeier
9/15/2003 10:24:30 AM

On the client, try creating a TCP/IP alias to the server
using the client network utility. Use the IP address for the
server name and the server name for the alias.
You could also try using an entry in the host file on the
client.

-Sue

On Mon, 15 Sep 2003 03:51:29 -0700, "Ling"
[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 about sql server odbc

sql server odbc : Can't connect SQL server through ODBC