We are suffering from dropped connections to our MSSQL server which is version:

Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

We are getting "ERROR: Prepare failed" from the application.

We suspect the ODBC drivers on the client may be old.

The ODBC driver on the client machine is version
2000.80.194.00. as taken from the driver tab in the odbc admin window.


I installed a 2000 base version of the client tools on my desktop and got an ODBC version of 2000.85.1117

I then installed the SP3a and the ODBC driver version did not change. What is the latest version of the driver for MSSQL 2000?

thanks
JB