Appendix C: ODBC Provider Properties
The following property sets are specific to the ODBC Provider.
The DBPROPSET_PROVIDERDATASOURCEINFO Property Set
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 object supports the optional Integrity Enhancement Facility |
KAGPROP_ODBCSQLCONFORMANCE |
VT_I4 |
SQL grammar supported by the ODBC driver |
The DBPROPSET_PROVIDERROWSET Property Set
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
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 |
Forces integrated security when you log on. Sets SQL_COPT_SS_SERV_RAC to the value of the BSTR. |
This topic is a part of: