Fix: ODBC PerfMon Pooling Counters Disappear if Other Non-ODBC Counters Are Present in PerfMon

View products that this article applies to.

This article was previously published under Q320498

Symptoms

If you add any non-ODBC counter together with any ODBC counter in Performance Monitor (PerfMon), you do not see any activity for the ODBC Counters.

↑ Back to the top

Cause

This is a bug in ODBC Driver Manager. When any non-ODBC counter is present in the list, the Driver Manager does not send any data back to Performance Monitor.

↑ Back to the top

Resolution

A supported hotfix is now available from Microsoft, but it is only intended to correct the problem that is described in this article. Only apply it to systems that are experiencing this specific problem. This hotfix may receive additional testing. Therefore, if you are not severely affected by this problem, we recommend that you wait for the next service pack that contains this hotfix.

To resolve this problem immediately, contact Microsoft Product Support Services to obtain the fix. For a complete list of Microsoft Product Support Services phone numbers and information about support costs, visit the following Microsoft Web site:

http://support.microsoft.com/contactus/?ws=support

NOTE: In special cases, charges that are ordinarily incurred for support calls may be canceled if a Microsoft Support Professional determines that a specific update will resolve your problem. The typical support costs will apply to additional support questions and issues that do not qualify for the specific update in question.

The English version of this fix should have the following file attributes or later:

MDAC 2.6 SP2

 Date         Version       Size     File name             Platform
 -----------------------------------------------------------------
 08-Apr-2002  3.520.8608.0  221,456  odbc32.dll                 x86
 26-Apr-2002  5.50.4134.600 197,392  Q320498_mdac26_x86_en.exe  x86

MDAC 2.7

 Date         Version        Size     File name              Platform
 ------------------------------------------------------------------
 16-Aug-2002  3.520.9001.17  204,800  odbc32.dll               x86
 23-Aug-2002  5.50.4134.600  194,832  Q320498_mdac27_x86.exe   x86

↑ Back to the top

Workaround

To workaround this problem, you must add only ODBC Performance Monitor counters in PerfMon. If you want to use a non-ODBC PerfMon counter, you must apply this fix.

↑ Back to the top