Export (0) Print
Expand All

Appendix C: Supported Properties of the Oracle Provider

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

Property

Short Description

DBPROP_CURRENTCATALOG

Current catalog.

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.

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.

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.

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.

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.

Show:
© 2014 Microsoft