SYSPROPS

The SYSPROPS attribute-keyword indicates whether the WMI ODBC adapter exposes WMI system properties. Set this keyword to TRUE to expose system properties; that is, in the connection string, include SYSPROPS=TRUE. You can also activate system properties with the check box control in the Configure Connection dialog box (using the WMI ODBC Adapter).

Currently, under certain queries, the use of SYSPROPS=TRUE results in some additional properties being returned which would not be expected in a typical SQL environment. For example, the following statement returns all system properties and all non-system properties, as expected:

SELECT * FROM MyClass

However, you cannot at this time specify the return of a partial set of the system properties. For example, the following statement returns MyProperty and ALL system properties.

SELECT __CLASS, MyProperty FROM MyClass

In addition, specifying only system properties in a select list returns all system properties and all non-system properties, as if you had specified SELECT * FROM MyClass instead of the following:

SELECT __CLASS FROM MyClass

Windows Server 2003: The WMI Open Database Connectivity (ODBC) Adapter is not available in Windows Server 2003. When you upgrade to Windows Server 2003, the WMI ODBC Adapter is not removed if it already exists on a computer. For an alternative type of data access, see Microsoft Data Access Components (MDAC).