Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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: