Index zu dynamischen ADO-Eigenschaften
Gilt für: Access 2013, Office 2013
Datenprovider, Dienstanbieter und Dienstkomponenten können den Properties-Auflistungen der nicht geöffneten Objekte Connection und Recordset dynamische Eigenschaften hinzufügen. Ein bestimmter Anbieter kann möglicherweise auch zusätzliche Eigenschaften hinzufügen, wenn diese Objekte geöffnet sind. Einige dieser Eigenschaften sind im Abschnitt "Dynamische ADO-Eigenschaften" aufgeführt. Weitere sind unter den jeweiligen Anbietern im Abschnitt "Anhang A: Anbieter" aufgeführt.
Bei der folgenden Tabelle handelt es sich um ein Cross-Index-System der ADO- und OLE DB-Namen für alle dynamischen Standardeigenschaften von OLE DB-Anbietern. Die Anbieter können mehr als die hier aufgeführten Eigenschaften hinzufügen. Gezielte Informationen zu anbieterspezifischen dynamischen Eigenschaften finden Sie in der Dokumentation zum Anbieter.
Die OLE DB-Programmierreferenz bezieht sich auf einen ADO-Eigenschaftsnamen durch den Begriff "Beschreibung". Weitere Informationen zu diesen Standardeigenschaften finden Sie in der OLE DB-Programmierreferenz. Suchen Sie im Index nach dem OLE DB-Eigenschaftennamen, oder lesen Sie die folgenden Abschnitte:
Appendix C: OLE DB Properties (in Englisch)
Supported Properties of the Cursor Service (in Englisch)
Supported Properties of the Persistence Provider (in Englisch)
Supported OLE DB Properties of the Remoting Provider (in Englisch)
Hinweise
Im Cross-Index verwendete Nummern:
(1) Bei dieser Eigenschaft handelt es sich um ein boolesches Flag, das angibt, ob die benannte Schnittstelle verwendet werden soll. Sofern vorhanden, ist der entsprechende OLE DB-Eigenschaftenname aufgeführt.
(2) The "Bookmarkable" ADO property is generated internally for backwards compatibility, and is mapped to the OLE DB property, DBPROP_IROWSETLOCATE. Diese Eigenschaft ist dieselbe wie die, die der ADO-Eigenschaft IRowsetLocate entspricht.
(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) Nicht zutreffend.
Dynamische Eigenschaften von "Connection"
ADO-Eigenschaftenname |
OLE DB-Eigenschaftenname |
|---|---|
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 |
Standort |
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 |
Dynamische Eigenschaften von "Recordset"
Die dynamischen Eigenschaften des Recordset-Objekts sind nicht mehr verfügbar, wenn das Recordset-Objekt geschlossen wird.
ADO-Eigenschaftenname |
OLE DB-Eigenschaftenname |
|---|---|
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 |
Privat1 |
(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 |