ADO Dynamic Property Index

Microsoft ActiveX Data Objects (ADO)

ADO 2.5 API Reference

ADO Dynamic Property Index

Data providers, service providers, and service components can add dynamic properties to the Properties collections of the unopened Connection and Recordset objects. A given provider may also insert additional properties when these objects are opened. Some of these properties are listed in the ADO Dynamic Properties section. More are listed under the specific providers in the Appendix A: Providers section.

The table below is a cross-index of the ADO and OLE DB names for each standard OLE DB provider dynamic property. Your providers may add more properties than listed here. For the specific information about provider-specific dynamic properties, see your provider documentation.

The OLE DB Programmer's Reference refers to an ADO property name by the term, "Description." You can find more information about these standard properties in the OLE DB Programmer's Reference. Search for the OLE DB property name in the Index or see the following topics:

  • Appendix C: OLE DB Properties
  • Supported Properties of the Cursor Service
  • Supported Properties of the Persistence Provider
  • Supported OLE DB Properties of the Remoting Provider

Remarks

Note numbers used in the cross-index:

(1) This property is a Boolean flag indicating whether the named interface should be used. The equivalent OLE DB property name is listed if it exists.

(2) The "Bookmarkable" ADO property is generated internally for backwards compatibility, and is mapped to the OLE DB property, DBPROP_IROWSETLOCATE. This is the same property that corresponds to the ADO property, IRowsetLocate.

(3) The ADO property name, "Hidden Columns", is named differently than the OLE DB property name Description, "Hidden Columns Count."

(4) For hierarchical recordsets, the "Maximum Rows" ADO property gets applied across all children. Depending on the order in which the rows are returned, you might have all, some or no children for each parent or orphaned children in the result set. Therefore, when reshaping hierarchical recordsets, the identifier for every child should be unique. In general, the Microsoft Data Shaping Service for OLE DB (MSDATASHAPE) provider does not allow for distinction between properties that can be inherited from the parent and those that cannot be inherited.

(5) Does not apply.

Connection Dynamic Properties

ADO Property Name OLE DB Property Name
Active Sessions DBPROP_ACTIVESESSIONS
Asynchable Abort DBPROP_ASYNCTXNABORT
Asynchable Commit DBPROP_ASYNCTNXCOMMIT
Autocommit Isolation Levels DBPROP_SESS_AUTOCOMMITISOLEVELS
Catalog Location DBPROP_CATALOGLOCATION
Catalog Term DBPROP_CATALOGTERM
Column Definition DBPROP_COLUMNDEFINITION
Connect Timeout DBPROP_INIT_TIMEOUT
Current Catalog DBPROP_CURRENTCATALOG
Data Source DBPROP_INIT_DATASOURCE
Data Source Name DBPROP_DATASOURCENAME
Data Source Object Threading Model DBPROP_DSOTHREADMODEL
DBMS Name DBPROP_DBMSNAME
DBMS Version DBPROP_DBMSVER
Extended Properties DBPROP_INIT_PROVIDERSTRING
GROUP BY Support DBPROP_GROUPBY
Heterogeneous Table Support DBPROP_HETEROGENEOUSTABLES
Identifier Case Sensitivity DBPROP_IDENTIFIERCASE
Initial Catalog DBPROP_INIT_CATALOG
Isolation Levels DBPROP_SUPPORTEDTXNISOLEVELS
Isolation Retention DBPROP_SUPPORTEDTXNISORETAIN
Locale Identifier DBPROP_INIT_LCID
Location DBPROP_INIT_LOCATION
Maximum Index Size DBPROP_MAXINDEXSIZE
Maximum Row Size DBPROP_MAXROWSIZE
Maximum Row Size Includes BLOB DBPROP_MAXROWSIZEINCLUDESBLOB
Maximum Tables in SELECT DBPROP_MAXTABLESINSELECT
Mode DBPROP_INIT_MODE
Multiple Parameter Sets DBPROP_MULTIPLEPARAMSETS
Multiple Results DBPROP_MULTIPLERESULTS
Multiple Storage Objects DBPROP_MULTIPLESTORAGEOBJECTS
Multi-Table Update DBPROP_MULTITABLEUPDATE
NULL Collation Order DBPROP_NULLCOLLATION
NULL Concatenation Behavior DBPROP_CONCATNULLBEHAVIOR
OLE DB Services DBPROP_INIT_OLEDBSERVICES
OLE DB Version DBPROP_PROVIDEROLEDBVER
OLE Object Support DBPROP_OLEOBJECTS
Open Rowset Support DBPROP_OPENROWSETSUPPORT
ORDER BY Columns in Select List DBPROP_ORDERBYCOLUMNSINSELECT
Output Parameter Availability DBPROP_OUTPUTPARAMETERAVAILABILITY
Pass By Ref Accessors DBPROP_BYREFACCESSORS
Password DBPROP_AUTH_PASSWORD
Persist Security Info DBPROP_AUTH_PERSIST_SENSITIVE_AUTHINFO
Persistent ID Type DBPROP_PERSISTENTIDTYPE
Prepare Abort Behavior DBPROP_PREPAREABORTBEHAVIOR
Prepare Commit Behavior DBPROP_PREPARECOMMITBEHAVIOR
Procedure Term DBPROP_PROCEDURETERM
Prompt DBPROP_INIT_PROMPT
Provider Friendly Name DBPROP_PROVIDERFRIENDLYNAME
Provider Name DBPROP_PROVIDERFILENAME
Provider Version DBPROP_PROVIDERVER
Read-Only Data Source DBPROP_DATASOURCEREADONLY
Rowset Conversions on Command DBPROP_ROWSETCONVERSIONSONCOMMAND
Schema Term DBPROP_SCHEMATERM
Schema Usage DBPROP_SCHEMAUSAGE
SQL Support DBPROP_SQLSUPPORT
Structured Storage DBPROP_STRUCTUREDSTORAGE
Subquery Support DBPROP_SUBQUERIES
Table Term DBPROP_TABLETERM
Transaction DDL DBPROP_SUPPORTEDTXNDDL
User ID DBPROP_AUTH_USERID
User Name DBPROP_USERNAME
Window Handle DBPROP_INIT_HWND

Recordset Dynamic Properties

Note that the Dynamic Properties of the Recordset object go out of scope (become unavailable) when the Recordset is closed.

ADO Property Name OLE DB Property Name
IAccessor DBPROP_IACCESSOR (1)
IChapteredRowset (1)
IColumnsInfo DBPROP_ICOLUMNSINFO (1)
IColumnsRowset DBPROP_ICOLUMNSROWSET (1)
IConnectionPointContainer DBPROP_ICONNECTIONPOINTCONTAINER (1)
IConvertType (1)
ILockBytes DBPROP_ILOCKBYTES (1)
IRowset DBPROP_IROWSET (1)
IDBAsynchStatus DBPROP_IDBASYNCHSTATUS (1)
IParentRowset (1)
IRowsetChange DBPROP_IROWSETCHANGE (1)
IRowsetExactScroll (1)
IRowsetFind DBPROP_IROWSETFIND (1)
IRowsetIdentity DBPROP_IROWSETIDENTITY (1)
IRowsetInfo DBPROP_IROWSETINFO (1)
IRowsetLocate DBPROP_IROWSETLOCATE (1)
IRowsetRefresh DBPROP_IROWSETREFRESH (1)
IRowsetResynch (1)
IRowsetScroll DBPROP_IROWSETSCROLL (1)
IRowsetUpdate DBPROP_IROWSETUPDATE (1)
IRowsetView DBPROP_IROWSETVIEW (1)
IRowsetIndex DBPROP_IROWSETINDEX (1)
ISequentialStream DBPROP_ISEQUENTIALSTREAM (1)
IStorage DBPROP_ISTORAGE (1)
IStream DBPROP_ISTREAM (1)
ISupportErrorInfo DBPROP_ISUPPORTERRORINFO (1)
Access Order DBPROP_ACCESSORDER
Append-Only Rowset DBPROP_APPENDONLY
Asynchronous Rowset Processing DBPROP_ROWSET_ASYNCH
Auto Recalc DBPROP_ADC_AUTORECALC
Background Fetch Size DBPROP_ASYNCHFETCHSIZE
Background Thread Priority DBPROP_ASYNCHTHREADPRIORITY
Batch Size DBPROP_ADC_BATCHSIZE
Blocking Storage Objects DBPROP_BLOCKINGSTORAGEOBJECTS
Bookmark Type DBPROP_BOOKMARKTYPE
Bookmarkable DBPROP_IROWSETLOCATE (2)
Bookmarks Ordered DBPROP_ORDEREDBOOKMARKS
Cache Child Rows DBPROP_ADC_CACHECHILDROWS
Cache Deferred Columns DBPROP_CACHEDEFERRED
Change Inserted Rows DBPROP_CHANGEINSERTEDROWS
Column Privileges DBPROP_COLUMNRESTRICT
Column Set Notification DBPROP_NOTIFYCOLUMNSET
Column Writable DBPROP_MAYWRITECOLUMN
Command Time Out DBPROP_COMMANDTIMEOUT
Cursor Engine Version DBPROP_ADC_CEVER
Defer Column DBPROP_DEFERRED
Delay Storage Object Updates DBPROP_DELAYSTORAGEOBJECTS
Fetch Backwards DBPROP_CANFETCHBACKWARDS
Filter Operations DBPROP_FILTERCOMPAREOPS
Find Operations DBPROP_FINDCOMPAREOPS
Hidden Columns (Count) DBPROP_HIDDENCOLUMNS (3)
Hold Rows DBPROP_CANHOLDROWS
Immobile Rows DBPROP_IMMOBILEROWS
Initial Fetch Size DBPROP_ASYNCHPREFETCHSIZE
Literal Bookmarks DBPROP_LITERALBOOKMARKS
Literal Row Identity DBPROP_LITERALIDENTITY
Maintain Change Status DBPROP_ADC_MAINTAINCHANGESTATUS
Maximum Open Rows DBPROP_MAXOPENROWS
Maximum Pending Rows DBPROP_MAXPENDINGROWS
Maximum Rows DBPROP_MAXROWS (4)
Memory Usage DBPROP_MEMORYUSAGE
Notification Granularity DBPROP_NOTIFICATIONGRANULARITY
Notification Phases DBPROP_NOTIFICATIONPHASES
Objects Transacted DBPROP_TRANSACTEDOBJECT
Others' Changes Visible DBPROP_OTHERUPDATEDELETE
Others' Inserts Visible DBPROP_OTHERINSERT
Own Changes Visible DBPROP_OWNUPDATEDELETE
Own Inserts Visible DBPROP_OWNINSERT
Preserve on Abort DBPROP_ABORTPRESERVE
Preserve on Commit DBPROP_COMMITPRESERVE
Private1 (5)
Quick Restart DBPROP_QUICKRESTART
Reentrant Events DBPROP_REENTRANTEVENTS
Remove Deleted Rows DBPROP_REMOVEDELETED
Report Multiple Changes DBPROP_REPORTMULTIPLECHANGES
Reshape Name DBPROP_ADC_RESHAPENAME
Resync Command DBPROP_ADC_CUSTOMRESYNCH
Return Pending Inserts DBPROP_RETURNPENDINGINSERTS
Row Delete Notification DBPROP_NOTIFYROWDELETE
Row First Change Notification DBPROP_NOTIFYROWFIRSTCHANGE
Row Insert Notification DBPROP_NOTIFYROWINSERT
Row Privileges DBPROP_ROWRESTRICT
Row Resynchronization Notification DBPROP_NOTIFYROWRESYNCH
Row Threading Model DBPROP_ROWTHREADMODEL
Row Undo Change Notification DBPROP_NOTIFYROWUNDOCHANGE
Row Undo Delete Notification DBPROP_NOTIFYROWUNDODELETE
Row Undo Insert Notification DBPROP_NOTIFYROWUNDOINSERT
Row Update Notification DBPROP_NOTIFYROWUPDATE
Rowset Fetch Position Change Notification DBPROP_NOTIFYROWSETFETCHPOSITIONCHANGE
Rowset Release Notification DBPROP_NOTIFYROWSETRELEASE
Scroll Backwards DBPROP_CANSCROLLBACKWARDS
Server Cursor DBPROP_SERVERCURSOR
Skip Deleted Bookmarks DBPROP_BOOKMARKSKIPPED
Strong Row Identity DBPROP_STRONGIDENTITY
Unique Catalog DBPROP_ADC_UNIQUECATALOG
Unique Rows DBPROP_UNIQUEROWS
Unique Schema DBPROP_ADC_UNIQUESCHEMA
Unique Table DBPROP_ADC_UNIQUETABLE
Updatability DBPROP_UPDATABILITY
Update Criteria DBPROP_ADC_UPDATECRITERIA
Update Resync DBPROP_ADC_UPDATERESYNC
Use Bookmarks DBPROP_BOOKMARKS

© 1998-2003 Microsoft Corporation. All rights reserved.