ODBC Provider Properties

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 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 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.