How to get WMI as ODBC data source in Win7 Pro ?

Hello friends,

I need to dig a bit into WMI, and found numerous references to using it via ODBC. For that I need to add "WBEM ODBC" to the ODBC data source list on my Win7pro system.

When I follow the steps on the MSDN web page, I get to the list of not-yet-added data sources, but WBEM ODBC isn't there. According to MSDN info, the ODBC driver for that should already be part of Win7, but I can't find it anywhere.

When I stress Google a bit, I find a very old MSI which seemed to be part of WinXP SP2 ... I've installed that in my desperation, but it didn't get visible in the list of not-yet-added data sources ... so I deinstalled it because it seemed not to be what I need.

Any hint how to get that ODBC data source accessible ?
LVL 14
frankhelkAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

David Johnson, CD, MVPOwnerCommented:
that is because it is not available via wmi only by the registry
powershell
get-itemproperty -path hklm:\software\odbc\odbcinst.ini\"Odbc drivers" |
get-member | where {$_.definition -match "installed"} |select-object name 

Open in new window


Get-OdbcDsn will show you what's available.
frankhelkAuthor Commented:
Hmmm - just to be clear: I don't want to query the installed ODBC drivers by WMI ... my target is to access WMI via ODBC.

I've tried your code, and it shows me the same result that I get by the way MSDN offers by Windows GUI means .... the same list on yet-to-be-installed data sources, where "WBEM ODBC" is missing.

Which leads me back to my initial question: Where is that "WBEM ODBC" driver, how can I d/l and install it, and if it's already on board in Win7, how do I access it as ODBC data source ?
CoralonCommented:
You need SMS/SCCM - https://msdn.microsoft.com/en-us/library/aa390889(v=vs.85).aspx.  But it is pretty straightforward.

Coralon
10 Tips to Protect Your Business from Ransomware

Did you know that ransomware is the most widespread, destructive malware in the world today? It accounts for 39% of all security breaches, with ransomware gangsters projected to make $11.5B in profits from online extortion by 2019.

frankhelkAuthor Commented:
Thanks for the link, but that is the link I've already included in my question :-S

In the procedure outlined, I'm stuck here:
snippet1.pngThere's simply not WBEN/WMI data source driver available:
snippet2.pngI'm running Win7pro x64, so the needed driver should be present, but I couldn't find it.

I've even searched Control Panel -> Software -> Windows Functions, but there's nothing that even vague reminds of incorporating such a thing like the missing driver.
CoralonCommented:
Don't forget to check the 32bit ODBC drivers - c:\windows\syswo64\odbcad32.exe

It may only be present with SMS/SCCM server.  But, I'm not sure :-\

Coralon
frankhelkAuthor Commented:
Thanks for that tip ... I've taken a look at the 32bit drivers and found a lot which were not listed in the regular view.

Unfortunately the WMI/WBEM driver was not among 'em.

Havn't found anything about the drivers and SMS/SSCM server.
CoralonCommented:
So, you are running MIcrosoft SMS server? or Microsoft SCCM server?  Without those, you will not have that driver.

Coralon
frankhelkAuthor Commented:
No ... I don't have one of those.

These products are the only source to get that driver ?
CoralonCommented:
Not sure.. I found some articles referencing this driver as an addon for the Windows 2000 install media.   This one makes it sound like it was dropped a long time ago -- https://www.autoitscript.com/forum/topic/87394-accessing-wmi-using-wbem-odbc/



Coralon

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
frankhelkAuthor Commented:
Thanks - that would point me into the right direction.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Development

From novice to tech pro — start learning today.