Possible to access WMI through ADO?

Question

Is there an OLEDB provider for WMI/WBEM?

In other words, could someone access WMI through:

• ADO in shell vbscript
• ADO in ASP script
• ADO in Win32 native process
• SQL Server linked server
• SQL Server OPENROWSET()

Is there an OLEDB provider for WMI/WBEM?

Is it possible to access WMI through ADO?

---

i hear rumors that an ODBC driver exists for WMI, but i cannot see it installed on my machine. Plus, i'm asking about OLEDB (and ADO that wraps it).

Answer 1

The answer is: No

There used to be an ODBC WMI adapter for Windows 2000 Server as an optional installation. (see here). It is not supported on later Windows versions (see here).

Answer 2

It would be too much work to wrap every class in WMI to OLDEB tables. Number of WMI classes exploded in the XP/2003 timeframe. If you are only focusing on certain classes, you can write your own OLEDB provider that calls WMI and returns the data.