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 following tables are cross-indexes 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." For more information about these standard properties, search or browse the index in the OLE DB documentationfor the OLE DB property by its name.

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
IChapteredRowset
IColumnsInfo	DBPROP_ICOLUMNSINFO
IColumnsRowset	DBPROP_ICOLUMNSROWSET
IConnectionPointContainer	DBPROP_ICONNECTIONPOINTCONTAINER
IConvertType
ILockBytes	DBPROP_ILOCKBYTES
IRowset	DBPROP_IROWSET
IDBAsynchStatus	DBPROP_IDBASYNCHSTATUS
IParentRowset
IRowsetChange	DBPROP_IROWSETCHANGE
IRowsetExactScroll
IRowsetFind	DBPROP_IROWSETFIND
IRowsetIdentity	DBPROP_IROWSETIDENTITY
IRowsetInfo	DBPROP_IROWSETINFO
IRowsetLocate	DBPROP_IROWSETLOCATE
IRowsetRefresh	DBPROP_IROWSETREFRESH
IRowsetResynch
IRowsetScroll	DBPROP_IROWSETSCROLL
IRowsetUpdate	DBPROP_IROWSETUPDATE
IRowsetView	DBPROP_IROWSETVIEW
IRowsetIndex	DBPROP_IROWSETINDEX
ISequentialStream	DBPROP_ISEQUENTIALSTREAM
IStorage	DBPROP_ISTORAGE
IStream	DBPROP_ISTREAM
ISupportErrorInfo	DBPROP_ISUPPORTERRORINFO
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
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
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
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
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