I've seen this error several times, but it happens so infrequently I always forget the solution. I thought I would record it here for posterity. If you have a Win2K box with a some ODBC databases installed you might may have seen an error appearing in your "application" log in the event viewer. The error is actually a pair of messages that occur together each second. The error is cryptic but seems to indicate trouble finding performance counters for ODBC.
The 2 errors are as follows. First there is the marker:
Although the error occurs each second it does not seem to have an appreciable performance impact. It can fill up your application log however, which will definitely cause other issues. On a busy server with lots of events it can even cause corruption in the application log. So it is probably a good idea to take care of it. It also makes it very difficult to sort out other errors from among the thousands of PerfMon ODBC errors.
From the Desktop go to START-->PROGRAMS-->ADMINISTRATIVE TOOLS-->Data Sources (ODBC) and click on the "Connection Pooling" tab at the top. In the upper right hand of the dialog box you will see an item that says "PerfMon" with a radio button to enable or disable. Set it to "enable". This will set the correct registry entries and cause the counters to load - thus taking away your error.
Of course this is a bit kludgy. There should be a way to disable the error message from firing at all. After all if you want the PerfMon counters to be disabled then the system shouldn't complain that it can't load the counters - right? Still, this will save you a lot of headaches in the long run. Why are you still using ODBC anyway? Oh yeah... Access :)