3

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).

Ian Boyd
  • 220,884
  • 228
  • 805
  • 1,125

2 Answers2

2

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).

Ian Boyd
  • 220,884
  • 228
  • 805
  • 1,125
  • i edited your question to include the answer of *no*; and marked it as answered. You get credit because you were in first. – Ian Boyd Nov 02 '09 at 21:18
0

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.

Sheng Jiang 蒋晟
  • 14,859
  • 2
  • 26
  • 44