Appendix C: Supported Properties of the Oracle Provider

Article
05/03/2017

The OLE DB properties supported by this provider are listed by PROPSETs, as follows:

DBPROPSET_DATASOURCE
DBPROPSET_DBINIT
DBPROPSET_DATASOURCEINFO
DBPROPSET_SESSION
DBPROPSET_ROWSET
DBPROPSET_MSDAORA_ROWSET

DBPROPSET_DATASOURCE

Property	Short Description
DBPROP_CURRENTCATALOG	Current catalog.

DBPROPSET_DBINIT

Property	Short Description
DBPROP_AUTH_PASSWORD	The password assigned to an Oracle user.
DBPROP_AUTH_USERID	The Oracle user ID to be used when connecting to the data source object or enumerator.
DBPROP_INIT_DATASOURCE	An existing Oracle server to connect to as the data source.
DBPROP_INIT_HWND	A window handle from the calling application.
DBPROP_INIT_LCID	This provider validates the locale ID and returns an error if the locale ID is not supported or is not installed on the client machine.
DBPROP_INIT_OLEDBSERVICES	A bitmask specifying OLE DB services to enable or disable.
DBPROP_INIT_PROMPT	This provider supports all prompting modes for data source object initialization. It uses DBPROMPT_NOPROMPT as its default setting for the property.
DBPROP_INIT_PROVIDERSTRING	A string containing provider-specific, extended connection information.

DBPROPSET_DATASOURCEINFO

Property	Short Description
DBPROP_ACTIVESESSIONS	The maximum number of session objects that can be active at one time.
DBPROP_ASYNCTXNABORT	Indicates whether transactions can be aborted asynchronously.
DBPROP_ASYNCTXNCOMMIT	Indicates whether transactions can be committed asynchronously.
DBPROP_BYREFACCESSORS	Indicates whether the provider supports the DBACCESSOR_PASSBYREF flag in IAccessor::CreateAccessor.
DBPROP_CATALOGLOCATION	Indicates the position of the catalog name in a qualified table name in a text command.
DBPROP_CATALOGTERM	Indicates the name the data source object uses for a catalog.
DBPROP_CATALOGUSAGE	Catalog usage. A bitmask specifying how catalog names can be used in text commands.
DBPROP_COLUMNDEFINITION	A bitmask defining the valid clauses for the definition of a column.
DBPROP_CONCATNULLBEHAVIOR	Indicates how the data source object handles the concatenation of NULL-valued character data type columns with non?NULL-valued character data type columns.
DBPROP_CONNECTIONSTATUS	Indicates the status of the current connection.
DBPROP_DATASOURCENAME	Indicates the name of the data source object.
DBPROP_DATASOURCEREADONLY	Indicates a read-only data source.
DBPROP_DBMSNAME	The name of the product accessed by the provider, such as "ORACLE Server".
DBPROP_DBMSVER	Indicates the version of the product accessed by the provider.
DBPROP_DSOTHREADMODEL	A bitmask specifying the threading models supported by the data source object.
DBPROP_GROUPBY	Indicates the relationship between the columns in a GROUP BY clause and the nonaggregated columns in the select list.
DBPROP_HETEROGENEOUSTABLES	A bitmask specifying whether the provider can join tables from different catalogs or providers.
DBPROP_IDENTIFIERCASE	Indicates how identifiers treat case in data definition commands or interfaces.
DBPROP_MAXINDEXSIZE	Indicates the maximum number of bytes allowed in the combined columns of an index.
DBPROP_MAXOPENCHAPTERS	Indicates the maximum number of chapters that can be open at any time.
DBPROP_MAXROWSIZE	Indicates the maximum length of a single row in a table.
DBPROP_MAXROWSIZEINCLUDESBLOB	Indicates whether the maximum row size includes BLOB length.
DBPROP_MAXTABLESINSELECT	Indicates the maximum number of tables allowed in the FROM clause of a SELECT statement.
DBPROP_MULTIPLEPARAMSETS	Indicates support for multiple parameter sets.
DBPROP_MULTIPLERESULTS	A bitmask specifying whether the provider supports multiple results objects and what restrictions it places on these objects.
DBPROP_MULTIPLESTORAGEOBJECTS	Indicates support for multiple, open storage objects at the same time.
DBPROP_MULTITABLEUPDATE	Indicates whether the provider can update rowsets derived from multiple tables.
DBPROP_NULLCOLLATION	Indicates where NULLs are sorted in a list.
DBPROP_OLEOBJECTS	A bitmask specifying the ways in which the provider supports access to BLOBs and COM objects stored in columns.
DBPROP_OPENROWSETSUPPORT	A bitmask describing support for opening objects through IOpenRowset.
DBPROP_ORDERBYCOLUMNSINSELECT	Indicates whether or not columns in an ORDER BY clause must be in the select list.
DBPROP_OUTPUTPARAMETERAVAILABILITY	Indicates the time at which output parameter values become available.
DBPROP_PERSISTENTIDTYPE	An integer specifying the type of DBID that the provider uses when persisting DBIDs that name entities in the data store, such as tables, indexes, columns, commands, or constraints.
DBPROP_PREPAREABORTBEHAVIOR	Indicates how aborting a transaction affects prepared commands.
DBPROP_PREPARECOMMITBEHAVIOR	Indicates how committing a transaction affects prepared commands.
DBPROP_PROCEDURETERM	A character string with the data store vendor's name for a procedure.
DBPROP_PROVIDERNAME	Indicates the file name of the provider.
DBPROP_PROVIDERFRIENDLYNAME	Indicates the friendly name of the provider.
DBPROP_PROVIDEROLEDBVER	Indicates the version of OLE DB supported by the provider.
DBPROP_PROVIDERVER	Indicates the version of the provider.
DBPROP_QUOTEDIDENTIFIERCASE	Indicates how quoted identifiers treat case.
DBPROP_ROWSETCONVERSIONSONCOMMAND	Indicates how rowset conversions on command are handled.
DBPROP_SCHEMATERM	The name the data source object uses for a schema.
DBPROP_SCHEMAUSAGE	A bitmask specifying how schema names can be used in text commands.
DBPROP_SQLSUPPORT	A bitmask specifying the level of support for SQL.
DBPROP_STRUCTUREDSTORAGE	A bitmask specifying what interfaces the rowset supports on storage objects.
DBPROP_SUBQUERIES	A bitmask specifying the predicates in text commands that support subqueries.
DBPROP_SUPPORTEDTXNDDL	Indicates the relationship of transactions to table and index modification data definition language (DDL) statements.
DBPROP_SUPPORTEDTXNISOLEVELS	A bitmask specifying the supported transaction isolation levels.
DBPROP_SUPPORTEDTXNISORETAIN	A bitmask specifying the supported transaction isolation retention levels.
DBPROP_TABLESTATISTICS	Bitmask indicating statistics support.
DBPROP_TABLETERM	Indicates the name the data source object uses for a table.
DBPROP_USERNAME	A character string with the name used in a particular database, which can be different than a login name.

DBPROPSET_SESSION

Property	Short Description
DBPROP_SESS_AUTOCOMMITISOLEVELS	A bitmask specifying the transaction isolation level while in auto-commit mode. This provider supports DBPROP_TI_READCOMMITED and DBPROP_TI_SERIALIZABLE.

DBPROP_SESS_AUTOCOMMITISOLEVELS

A bitmask specifying the transaction isolation level while in auto-commit mode.

This provider supports DBPROP_TI_READCOMMITED and DBPROP_TI_SERIALIZABLE.

DBPROPSET_ROWSET

Property	Short Description
DBPROP_IAccessor	R/W: Read-only Default: VARIANT_TRUE The value of this property is read-only and is always set to VARIANT_TRUE, indicating that the rowset supports IAccessor.
DBPROP_IColumnsInfo	R/W: Read-only Default: VARIANT_TRUE The value of this property is read-only and is always set to VARIANT_TRUE, indicating that the rowset supports IColumnsInfo.
DBPROP_IColumnsRowset	R/W: Read-only Default: Indicates whether or not the rowset supports IColumnsRowset.
DBPROP_IConnectionPointContainer	R/W: Read-only Default: VARIANT_TRUE Indicates whether or not the rowset supports IConnectionPointContainer.
DBPROP_IConvertType	R/W: Read-only Default: VARIANT_TRUE The value of this property is read-only and is always set to VARIANT_TRUE, indicating that the rowset supports IConvertType.
DBPROP_IRowset	R/W: Read-only Default: VARIANT_TRUE The value of this property is read-only and is always set to VARIANT_TRUE, indicating that the rowset supports IRowset.
DBPROP_IRowsetIdentity	R/W: Read-only Default: VARIANT_TRUE Indicates whether or not the rowset supports IRowsetIdentity.
DBPROP_IRowsetInfo	R/W: Read-only Default: VARIANT_TRUE The value of this property is read-only and is always set to VARIANT_TRUE, indicating that the rowset supports IRowsetInfo.
DBPROP_ISupportErrorInfo	R/W: Read-only Default: VARIANT_TRUE Indicates whether or not the rowset supports ISupportErrorInfo.
DBPROP_ISequentialStream	R/W: Read-only Default: VARIANT_TRUE If the value of this property is set to VARIANT_TRUE, the rowset is capable of manipulating the contents of columns as a storage object supporting the specified interface.
DBPROP_ABORTPRESERVE	R/W: Read-only Default: VARIANT_FALSE After aborting a transaction, the only operations allowed on a rowset are ReleaseRows, ReleaseAccessor, and Releasing Rowsets.
DBPROP_ACCESSORDER	R/W: Read-only Default: Sets the order in which columns must be accessed by methods that operate on rowsets, rows, and streams.
DBPROP_BLOCKINGSTORAGEOBJECTS	R/W: Read-only Default: VARIANT_FALSE Indicates whether storage objects might prevent use of other methods on the rowset.
DBPROP_BOOKMARKS	R/W: Read-only Default: VARIANT_FALSE Indicates whether the rowset supports bookmarks.
DBPROP_CACHEDEFERRED	R/W: Read-only Default: VARIANT_FALSE Indicates whether or not the provider caches the value of a deferred column.
DBPROP_CANFETCHBACKWARDS	R/W: Read-only Default: VARIANT_FALSE Indicates whether the rowset can fetch backward.
DBPROP_CANHOLDROWS	R/W: Read-only Default: VARIANT_TRUE Indicates whether or not the rowset allows the consumer to retrieve more rows or change the next fetch position, while holding previously fetched rows or rows with pending changes.
DBPROP_CANSCROLLBACKWARDS	R/W: Read-only Default: VARIANT_FALSE Indicates whether the rowset can scroll backward.
DBPROP_COMMITPRESERVE	R/W: Read-only Default: VARIANT_TRUE Indicates whether or not the rowset remains active after committing a transaction
DBPROP_DEFERRED	R/W: Read-only Default: VARIANT_FALSE Indicates whether or not the data in the column is not fetched until an accessor is used on the column.
DBPROP_HIDDENCOLUMNS	R/W: Read-only Default: Returns the number of additional "hidden" columns added by the provider to uniquely identify rows within the rowset.
DBPROP_LITERALIDENTITY	R/W: Read-only Default: VARIANT_TRUE Indicates whether or not the consumer can perform a binary comparison of two row handles to determine whether they point to the same row.
DBPROP_MAXOPENROWS	R/W: Read-only Default: 0 Indicates the maximum number of rows that can be active at the same time.
DBPROP_MAXROWS	R/W: Read/Write Default: 0 Indicates the maximum number of rows that can be returned in a rowset.
DBPROP_NOTIFICATIONGRANULARITY	R/W: Read-only Default:DBPROPVAL_NT_MULTIPLEROWS Provides the notification granularity.
DBPROP_NOTIFICATIONPHASES	R/W: Read-only Default: DBPROPVAL_NP_OKTODO DBPROPVAL_NP_ABOUTTODO DBPROPVAL_NP_SYNCHAFTER DBPROPVAL_NP_FAILEDTODO BPROPVAL_NP_DIDEVENT A bitmask specifying the notification phases supported by the provider.
DBPROP_NOTIFYROWSETRELEASE	R/W: Read-only Default: DBPROPVAL_NP_OKTODO DBPROPVAL_NP_ABOUTTODO A bitmask specifying whether the notification phase is cancelable.
DBPROP_NOTIFYROWSETFETCHPOSITIONCHANGE	R/W: Read-only Default: DBPROPVAL_NP_OKTODO DBPROPVAL_NP_ABOUTTODO A bitmask specifying whether the notification phase is cancelable.
DBPROP_OTHERINSERT	R/W: Read-only Default: VARIANT_FALSE Indicates whether or not rows inserted by a consumer or process other than a consumer of the rowset are visible.
DBPROP_OTHERUPDATEDELETE	R/W: Read-only Default: VARIANT_FALSE Indicates whether or not rows modified (updated or deleted) by a consumer or process other than a consumer of the rowset are visible.
DBPROP_OWNINSERT	R/W: Read-only Default: VARIANT_FALSE Indicates whether or not the inserts to the rowset are visible.
DBPROP_OWNUPDATEDELETE	R/W: Read-only Default: VARIANT_FALSE Indicates whether or not the updates and deletes made by the rowset consumer are visible.
DBPROP_QUICKRESTART	R/W: Read-only Default: VARIANT_FALSE Indicates whether IRowset::RestartPosition is relatively quick to execute.
DBPROP_REENTRANTEVENTS	R/W: Read-only Default: VARIANT_FALSE Indicates whether the provider supports reentrancy during callbacks to the IRowsetNotify interface.
DBPROP_REMOVEDELETED	R/W: Read-only Default: False Indicates whether the provider removes rows it detects as having been deleted from the rowset.
DBPROP_ROWTHREADMODEL	R/W: Read-only Default: DBPROPVAL_RT_FREETHREAD A bitmask specifying the threading models supported by the rowset.
DBPROP_SERVERCURSOR	R/W: Read-only Default: VARIANT_FALSE Works in conjunction with other cursor properties, including DBPROP_CLIENTCURSOR, to determine where a cursor, if required, is materialized.
DBPROP_STRONGIDENTITY	R/W: Read-only Default: VARIANT_TRUE Indicates whether or not the handles of newly inserted rows can be compared.
DBPROP_TRANSACTEDOBJECT	R/W: Read-only Default: VARIANT_FALSE Indicates whether or not any object created on the specified column is transacted.
DBPROP_UNIQUEROWS	R/W: Read/Write Default: VARIANT_FALSE Indicates whether or not each row is uniquely identified by its column values.

DBPROPSET_MSDAORA_ROWSET

Property	Short Description
DBPROP_MSDAORA_DETERMINEKEYCOLUMNS	R/W: Read/Write Default: VARIANT_FALSE Indicates whether or not each a row is uniquely identified by its key column so a ROWID will not be generated. DBPROP_UNIQUEROWS must be set to true.

DBPROP_MSDAORA_DETERMINEKEYCOLUMNS

R/W: Read/Write

Default: VARIANT_FALSE

Indicates whether or not each a row is uniquely identified by its key column so a ROWID will not be generated. DBPROP_UNIQUEROWS must be set to true.