Knowledge Base

FIX: No Data in ODBC Performance Log If Stopped/Restarted

Article ID: 157801

Article Last Modified on 10/3/2003

Microsoft SQL Server 6.5 Standard Edition

This article was previously published under Q157801

SYMPTOMS

If an Open Database Connectivity (ODBC) application stops and then restarts, the ODBC driver's performance statistics will log the following:

   retcode = SQLSetConnectOption
             (hdbc,
             SQL_COPT_SS_PERF_DATA,
             SQL_PERF_STOP);
   retcode = SQLSetConnectOption
             (hdbc,
             SQL_COPT_SS_PERF_DATA,
             SQL_PERF_START);

The log file will only have its header information; it will not contain any data.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft SQL Server ODBC Driver version 2.65. This problem has been corrected in U.S. Service Pack 2 for Microsoft SQL Server version 6.5. For more information, contact your primary support provider.

Keywords: kbbug kbfix kbinterop KB157801