ADO 动态属性索引

适用于：Access 2013、Office 2013

数据提供程序、服务提供程序及服务组件可以将动态属性添加到未打开的 Connection 和 Recordset 对象的 Properties 集合中。 打开这些对象时，给定的提供程序还可以插入其他属性。 其中的一些属性在 ADO 动态属性 一节中列出。 更多其他属性在 附录 A：提供程序一节的特定提供程序下列出。

下表是每个标准 OLE DB 提供程序动态属性的 ADO 和 OLE DB 名称的交叉索引。 除了此处列出的属性外，提供程序还可能添加更多的属性。 有关提供程序特定动态属性的具体信息，请参阅提供程序文档。

OLE DB 程序员参考通过术语“说明”引用 ADO 属性名称。可以在 OLE DB 程序员参考中找到有关这些标准属性的详细信息。 请在"索引"中搜索 OLE DB 属性名或参阅以下主题：

• 附录 C：OLE DB 属性

• Cursor Service 支持的属性

• 持久性提供程序支持的属性

• 远程提供程序支持的 OLE DB 属性

备注

请注意交叉索引中使用的数字：

(1) 此属性是一个 Boolean 标志，指示是否应使用指定接口。 将列出等效的 OLE DB 属性名（如果存在）。

(2) 内部生成的"Bookmarkable"ADO 属性具备向后兼容性，且将被映射到 OLE DB 属性 DBPROP_IROWSETLOCATE。 此属性是与 ADO 属性 IRowsetLocate 对应的同一属性。

(3) ADO 属性名"Hidden Columns"的命名不同于 OLE DB 属性名说明"Hidden Columns Count"。

(4) 对于分级记录集，"Maximum Rows"ADO 属性应用于所有的子记录集。 根据行的返回顺序，结果集中的每个父记录集和孤立子记录集可能都具有子记录集，有一些具有子记录集，或者都没有子记录集。 因此，重构分级记录集时，每个子记录集的标识符都应该是唯一的。 一般情况下，Microsoft Data Shaping Service for OLE DB (MSDATASHAPE) 提供程序不考虑可从父记录集继承的属性与不能继承的属性间的区别。

(5) 不适用。

Connection 动态属性

ADO 属性名	OLE DB 属性名
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
位置	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
模式	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 动态属性

请注意，关闭 Recordset 时， Recordset 对象的 动态属性 将超出范围（不可用）。

ADO 属性名	OLE DB 属性名
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