下表是每个动态属性的 ADO 和 OLE DB 名称的交叉索引。OLE DB Programmer's Reference 使用“Description”项引用 ADO 属性名称。有关这些属性的详细信息,请参阅 OLE DB Programmer's Reference。请在“索引”中搜索 OLE DB 属性名称或参阅 Appendix C:OLE DB Properties。
Connection 动态属性
下列属性被添加到 Connection 对象的 Properties 集合中。
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
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
GROUP BY Support
DBPROP_GROUPBY
Heterogeneous Table Support
DBPROP_HETEROGENEOUSTABLES
Identifier Case Sensitivity
DBPROP_IDENTIFIERCASE
Isolation Levels
DBPROP_SUPPORTEDTXNISOLEVELS
Isolation Retention
DBPROP_SUPPORTEDTXNISORETAIN
Locale Identifier
DBPROP_INIT_LCID
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 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
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 对象的 Properties 集合中。
ADO 属性名称
OLE DB 属性名称
Access Order
DBPROP_ACCESSORDER
Append-Only Rowset
DBPROP_APPENDONLY
Blocking Storage Objects
DBPROP_BLOCKINGSTORAGEOBJECTS
Bookmark Type
DBPROP_BOOKMARKTYPE
Bookmarkable
DBPROP_IROWSETLOCATE
Bookmarks Ordered
DBPROP_ORDEREDBOOKMARKS
Cache Deferred Columns
DBPROP_CACHEDEFERRED
Change Inserted Rows
DBPROP_CHANGEINSERTEDROWS
Column Privileges
DBPROP_COLUMNRESTRICT
Column Set Notification
DBPROP_NOTIFYCOLUMNSET
Column Writable
DBPROP_MAYWRITECOLUMN
Defer Column
DBPROP_DEFERRED
Delay Storage Object Updates
DBPROP_DELAYSTORAGEOBJECTS
Fetch Backwards
DBPROP_CANFETCHBACKWARDS
Hold Rows
DBPROP_CANHOLDROWS
IAccessor
DBPROP_IAccessor
IColumnsInfo
DBPROP_IColumnsInfo
IColumnsRowset
DBPROP_IColumnsRowset
IConnectionPointContainer
DBPROP_IConnectionPointContainer
IConvertType
DBPROP_IConvertType
ILockBytes
DBPROP_ILockBytes
Immobile Rows
DBPROP_IMMOBILEROWS
IRowset
DBPROP_IRowset
IRowsetChange
DBPROP_IRowsetChange
IRowsetIdentity
DBPROP_IRowsetIdentity
IRowsetIndex
DBPROP_IRowsetIndex
IRowsetInfo
DBPROP_IRowsetInfo
IRowsetLocate
DBPROP_IRowsestLocate
IRowsetResynch
IRowsetScroll
DBPROP_IRowsetScroll
IRowsetUpdate
DBPROP_IRowsetUpdate
ISequentialStream
DBPROP_ISequentialStream
IStorage
DBPROP_IStorage
IStream
DBPROP_IStream
ISupportErrorInfo
DBPROP_ISupportErrorInfo
Literal Bookmarks
DBPROP_LITERALBOOKMARKS
Literal Row Identity
DBPROP_LITERALIDENTITY
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
Quick Restart
DBPROP_QUICKRESTART
Reentrant Events
DBPROP_REENTRANTEVENTS
Remove Deleted Rows
DBPROP_REMOVEDELETED
Report Multiple Changes
DBPROP_REPORTMULTIPLECHANGES
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_NOTIFYROWSETFETCHPOSISIONCHANGE
Rowset Release Notification
DBPROP_NOTIFYROWSETRELEASE
Scroll Backwards
DBPROP_CANSCROLLBACKWARDS
Skip Deleted Bookmarks
DBPROP_BOOKMARKSKIPPED
Strong Row Identity
DBPROP_STRONGITDENTITY
Updatability
DBPROP_UPDATABILITY
Use Bookmarks
DBPROP_BOOKMARKS
Command 动态属性
下列属性被添加到 Command 对象的 Properties 集合中。
ADO 属性名称
OLE DB 属性名称
Access Order
DBPROP_ACCESSORDER
Append-Only Rowset
DBPROP_APPENDONLY
Blocking Storage Objects
DBPROP_BLOCKINGSTORAGEOBJECTS
Bookmark Type
DBPROP_BOOKMARKTYPE
Bookmarkable
DBPROP_IROWSETLOCATE
Change Inserted Rows
DBPROP_CHANGEINSERTEDROWS
Column Privileges
DBPROP_COLUMNRESTRICT
Column Set Notification
DBPROP_NOTIFYCOLUMNSET
Defer Column
DBPROP_DEFERRED
Delay Storage Object Updates
DBPROP_DELAYSTORAGEOBJECTS
Fetch Backwards
DBPROP_CANFETCHBACKWARDS
Hold Rows
DBPROP_CANHOLDROWS
IAccessor
DBPROP_IAccessor
IColumnsInfo
DBPROP_IColumnsInfo
IColumnsRowset
DBPROP_IColumnsRowset
IConnectionPointContainer
DBPROP_IConnectionPointContainer
IConvertType
DBPROP_IConvertType
ILockBytes
DBPROP_ILockBytes
Immobile Rows
DBPROP_IMMOBILEROWS
IRowset
DBPROP_IRowset
IRowsetChange
DBPROP_IRowsetChange
IRowsetIdentity
DBPROP_IRowsetIdentity
IRowsetIndex
DBPROP_IRowsetIndex
IRowsetInfo
DBPROP_IRowsetInfo
IRowsetLocate
DBPROP_IRowsetLocate
IRowsetResynch
IRowsetScroll
DBPROP_IRowsetScroll
IRowsetUpdate
DBPROP_IRowsetUpdate
ISequentialStream
DBPROP_ISequentialStream
IStorage
DBPROP_IStorage
IStream
DBPROP_IStream
ISupportErrorInfo
DBPROP_ISupportErrorInfo
Literal Bookmarks
DBPROP_LITERALBOOKMARKS
Literal Row Identity
DBPROP_LITERALIDENTITY
Lock Mode
DBPROP_LOCKMODE
Maximum Open Rows
DBPROP_MAXOPENROWS
Maximum Pending Rows
DBPROP_MAXPENDINGROWS
Maximum Rows
DBPROP_MAXROWS
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
Quick Restart
DBPROP_QUICKRESTART
Reentrant Events
DBPROP_REENTRANTEVENTS
Remove Deleted Rows
DBPROP_REMOVEDELETED
Report Multiple Changes
DBPROP_REPORTMULTIPLECHANGES
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 Data on Insert
DBPROP_SERVERDATAONINSERT
Skip Deleted Bookmarks
DBPROP_BOOKMARKSKIP
Strong Row Identity
DBPROP_STRONGIDENTITY
Updatability
DBPROP_UPDATABILITY
Use Bookmarks
DBPROP_BOOKMARKS
请参阅 有关 OLE DB Provider for Microsoft Jet 的特定实现和功能的详细信息,请参阅 MDAC SDK 中的 OLE DB Provider for Microsoft Jet 文档。