Win32_ODBCDataSourceSpecification vbscript sample code | ActiveXperts Network Monitor

The foundations for Manageability in Windows is Windows Management Instrumentation (WMI; formerly WBEM) and WMI extensions for Windows Driver Model (WDM).

ActiveXperts Network Monitor provides the ability to build monitor check routines based on WMI. ActiveXperts has collected more than a hundred WMI samples. You can use these samples as a base for new check routines you can write yourself. The Win32_ODBCDataSourceSpecification WMI class can be used in ActiveXperts Network Monitor to monitor your servers.

---

Description

The Win32_ODBCDataSourceAttribute association WMI class relates an Installer check with any setting information it requires.

Sample Code

On Error Resume Next
strComputer = "."
Set objWMIService = GetObject("winmgmts:\\" & strComputer & "\root\cimv2")
Set colItems = objWMIService.ExecQuery("Select * from Win32_ODBCDataSourceSpecification",,48)
For Each objItem in colItems
    Wscript.Echo "Caption: " & objItem.Caption
    Wscript.Echo "CheckID: " & objItem.CheckID
    Wscript.Echo "CheckMode: " & objItem.CheckMode
    Wscript.Echo "DataSource: " & objItem.DataSource
    Wscript.Echo "Description: " & objItem.Description
    Wscript.Echo "DriverDescription: " & objItem.DriverDescription
    Wscript.Echo "Name: " & objItem.Name
    Wscript.Echo "Registration: " & objItem.Registration
    Wscript.Echo "SoftwareElementID: " & objItem.SoftwareElementID
    Wscript.Echo "SoftwareElementState: " & objItem.SoftwareElementState
    Wscript.Echo "TargetOperatingSystem: " & objItem.TargetOperatingSystem
    Wscript.Echo "Version: " & objItem.Version
Next