I am interested leveraging the ease of report production provided by Microsoft SQL Report Builder
, but I would like WMI
as an available datasource. Since SQL Report Builder
relies only on SQL, I would like to install the WMI ODBC
driver on Windows 7, but the instructions from the MSFT site must cover XP, as the WMI ODBC
driver is not apparently available.
How do I install the WMI ODBC
driver on Windows 7?
Microsoft discontinued the MDAC object set as 2005, and supported OSes as of XP (even server 2003 does not fully support MDAC, particularly WMI ODBC is not supported). Windows Vista and newer OSes only support WinDAC, which does not offer WMI via ODBC.
Side note: WMI isn't always the best interface to poke at, parts of it are terribly broken and even doing mundane queries can break your Windows installation.