My application (a commercial application written in Powerbuilder) is frequently crashing and the following error message is recorded in the application's log:
SQL Error Text: Select error: SQLSTATE = 08S01
[Microsoft][ODBC SQL Server Driver]Communication link failure
Based on Google searches this indicates the LAN connection was dropped.
The database is MS SQL Server 2000. The server is an HP Proliant ML370. The switch is an HP Procurve 2650. The workstations are P4, WinXP, 512MB RAM, NeXtreme Gigabit Ethernet. The cabling is CAT5E.
The Procurve switch sofware indicates zero network errors.
Set the server and workstation NIC speeds to 100HDx. (No improvement).
Checked the physical connections which appear to be okay.
Ran diagnostics on the NIC cards. No problems were reported.
What else should I be checking?