ADO dynamic property index
Applies to: Access 2013, Office 2013
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 |