The following property sets are specific to the ODBC Provider.
The DBPROPSET_PROVIDERDATASOURCEINFO property set contains the following properties.
| Property name | Variant type | Description |
| KAGPROP_ACCESSIBLEPROCEDURES | VT_BOOL | Accessible procedures |
| KAGPROP_ACCESSIBLETABLES | VT_BOOL | Accessible tables |
| KAGPROP_ ACTIVESTATEMENTS | VT_I4 | Active statements |
| KAGPROP_OJCAPABILITY | VT_I4 | Outer join capabilities |
| KAGPROP_PROCEDURES | VT_BOOL | Stored procedures available |
| KAGPROP_DRIVERNAME | VT_BSTR | ODBC Driver name |
| KAGPROP_DRIVERVER | VT_BSTR | ODBC Driver version |
| KAGPROP_DRIVERODBCVER | VT_BSTR | Driver ODBC version |
| KAGPROP_FILEUSAGE | VT_I4 | File usage |
| KAGPROP_LIKEESCAPECLAUSE | VT_BSTR | Like escape clause |
| KAGPROP_SPECIALCHARACTERS | VT_BSTR | Special characters |
| KAGPROP_MAXCOLUMNSINGROUPBY | VT_I4 | Maximum columns in Group By clause |
| KAGPROP_MAXCOLUMNSININDEX | VT_I4 | Maximum columns in index |
| KAGPROP_MAXCOLUMNSINORDERBY | VT_I4 | Maximum columns in Order By clause |
| KAGPROP_MAXCOLUMNSINSELECT | VT_I4 | Maximum columns in Select statement |
| KAGPROP_MAXCOLUMNSINTABLE | VT_I4 | Maximum columns in table |
| KAGPROP_NUMERICFUNCTIONS | VT_I4 | Numeric functions |
| KAGPROP_OUTERJOINS | VT_BSTR | Outer joins |
| KAGPROP_STRINGFUNCTIONS | VT_I4 | String functions |
| KAGPROP_SYSTEMFUNCTIONS | VT_I4 | System functions |
| KAGPROP_TIMEDATEFUNCTIONS | VT_I4 | Time and date functions |
| KAGPROP_ODBCSQLOPTIEF | VT_BOOL | Indicates whether the data source supports the optional Integrity Enhancement Facility |
| KAGPROP_ODBCSQLCONFORMANCE | VT_I4 | SQL grammar supported by the ODBC driver |
The DBPROPSET_PROVIDERROWSET property set contains the following properties.
| Property name | Variant type | Description |
| KAGPROP_QUERYBASEDUPDATES | VT_BOOL | Query-based updates, deletes, and inserts |
| KAGPROP_CONCURRENCY | VT_UI4 | Mask of ODBC concurrency to support. The following bitmask values apply to this option: KAGPROPVAL_CONCUR_READ_ONLY KAGPROPVAL_CONCUR_ROWVER KAGPROPVAL_CONCUR_VALUES KAGPROPVAL_CONCUR_LOCK |
| KAGPROP_BLOBSONFOCURSOR | VT_BOOL | BLOB accessibility on forward-only cursors |
| KAGPROP_INCLUDENONEXACT | VT_BOOL | Include SQL_FLOAT, SQL_DOUBLE, and SQL_REAL in QBU WHERE clauses |
| KAGPROP_MARSHALLABLE | VT_BOOL | Generate a rowset that can be marshaled |
| KAGPROP_POSITIONONNEWROW | VT_BOOL | Position on the last row after the insert operation completes |
| KAGPROP_IROWSETCHANGEEXTINFO | VT_BOOL | IRowsetChange interface extended information support |
| KAGPROP_CURSOR | VT_I4 | ODBC cursor type |
The DBPROPSET_PROVIDERDBINIT property set contains the following properties.
| Property name | Variant type | Description |
| KAGPROP_AUTHTRUSTEDCONNECTION | VT_BOOL | Trusted connection. Sets SQL_COPT_SS_SERV_RAC to the value of the BSTR. Sets SQL_COPT_SS_INTEGRATED_SECURITY to SQL_IS_ON. |
| KAGPROP_AUTHSERVERINTEGRATED | VT_BOOL | Force integrated security when you log on. Sets SQL_COPT_SS_SERV_RAC to the value of the BSTR. |