problem connecting Access 2003 to SQLS2000 (ODBC connection)

[psimon88]

Hello

I am running Access 2003 and connecting my tables via ODBC to SQL Server 2000. I am getting this error when I try to hit the tables:

ODBC - CALL FAILED
MICROSOFT. ODBC SQL SERVER DRIVER. TCP/IP SOCKETS. CONNECTIONREAD(REC(). (#10054) MICROSOFT ODBC SQL SERVER TRIVER. TCIP/IP SOCKETS. GENERAL NETWORK ERROR. CHECK YOUR NETWORK DOCUMENTATION. #11.

Any idea about how to resolve this? I am able to run queries through SQL Analyser against the same dB. I tried resetting the DNS connection but that hasnt' worked.

Thanks in advance.

ps

 

[nomadicalloy]

This is network issue. I get this sometimes from querry analyzer.

SQL Help Blog

http://www.xpherion.com/blog.asp