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: