Communication Link Failure Between Client and SQL Server

Communication Link Failure Between Client and SQL Server

Post by Luke » Fri, 13 Apr 2001 01:27:09



Hi,

One of our internal customers sometimes meets the problem when he is running
ERP application. The problem is that the ERP system is hung. I check the
error log produced by ERP. It shows:
SQLSTATE 08s01, which means communication link failure.

I open ODBC in Control Panel. I even can not connect to database using any
DSN. The error message is the same as above. But I can PING the database
server successfully. I also check SQL Server. It seems healthy.

The following is the configuration of server and client:

Server:    SQL7.0/SP2
                NT4.0/SP6a
                MDAC 2.5
                VC 5.0

Client:    NT Workstation 4.0/SP6a
            MDAC 2.5

If someone has any suggestions?

Thanks.

Luke