Index des propriétés dynamiques ADO
Les fournisseurs de données, les fournisseurs de services et les composants de service peuvent ajouter des propriétés dynamiques aux collections Properties des objets Connection et Recordset non ouverts. Un fournisseur donné peut également insérer des propriétés supplémentaires quand ces objets sont ouverts. Certaines de ces propriétés sont listées dans la section Propriétés dynamiques ADO. D’autres sont listées sous les fournisseurs spécifiques de la section Annexe A : Fournisseurs.
Les tableaux suivants sont des index croisés des noms ADO et OLE DB de chaque propriété dynamique du fournisseur OLE DB standard. Vos fournisseurs peuvent ajouter plus de propriétés que celles listées ici. Pour plus d’informations sur les propriétés dynamiques spécifiques du fournisseur, consultez la documentation de votre fournisseur.
La référence du programmeur OLE DB désigne un nom de propriété ADO par le terme « Description ». Pour plus d’informations sur ces propriétés standard, parcourez l’index dans la documentation OLE DB pour rechercher la propriété OLE DB à partir de son nom.
Propriétés dynamiques de connexion
| Nom de la propriété ADO | Nom de la propriété OLE DB |
|---|---|
| Sessions actives | 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 |
| source de données | DBPROP_INIT_DATASOURCE |
| Nom de la source de données | 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 |
| Niveaux d’isolation | DBPROP_SUPPORTEDTXNISOLEVELS |
| Isolation Retention | DBPROP_SUPPORTEDTXNISORETAIN |
| Identificateur de paramètres régionaux | DBPROP_INIT_LCID |
| Emplacement | 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 |
| Résultats multiples | 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 |
| Mot de passe | 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 |
| Nom du fournisseur | DBPROP_PROVIDERFILENAME |
| Version du fournisseur | DBPROP_PROVIDERVER |
| Read-Only Data Source | DBPROP_DATASOURCEREADONLY |
| Rowset Conversions on Command | DBPROP_ROWSETCONVERSIONSONCOMMAND |
| Schema Term | DBPROP_SCHEMATERM |
| Schema Usage | DBPROP_SCHEMAUSAGE |
| Prise en charge SQL | DBPROP_SQLSUPPORT |
| Structured Storage | DBPROP_STRUCTUREDSTORAGE |
| Subquery Support | DBPROP_SUBQUERIES |
| Table Term | DBPROP_TABLETERM |
| Transaction DDL | DBPROP_SUPPORTEDTXNDDL |
| ID d'utilisateur | DBPROP_AUTH_USERID |
| User Name | DBPROP_USERNAME |
| Handle de la fenêtre | DBPROP_INIT_HWND |
Propriétés dynamiques du recordset
Notez que les propriétés dynamiques de l’objet Recordset sortent de l’étendue (deviennent indisponibles) quand le Recordset est fermé.
| Nom de la propriété ADO | Nom de la propriété OLE DB |
|---|---|
| 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 |
| Priorité de thread en arrière-plan | DBPROP_ASYNCHTHREADPRIORITY |
| Taille du lot | 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 |
| Utilisation de la mémoire | 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 |
| table unique | DBPROP_ADC_UNIQUETABLE |
| Updatability | DBPROP_UPDATABILITY |
| Update Criteria | DBPROP_ADC_UPDATECRITERIA |
| Update Resync | DBPROP_ADC_UPDATERESYNC |
| Use Bookmarks | DBPROP_BOOKMARKS |