Microsoft OLE DB 2.0 Programmers Reference and Data Access SDK (Microsoft Professional Editions)
| OLE DB Programmer's Reference |
The properties listed in this section are contained in the designated property sets and property groups. (For a listing of properties organized by property group, see "Properties by Property Groups.") The "Column?" designation for Rowset properties states whether the property can be set on individual columns or only on the rowset as a whole.
Important The "Typical R/W" value for each property specifies whether that property can typically be read or written. Whether a particular property can actually be read or written is provider-specific and is returned in the dwPropFlags element of the DBPROPINFO structure.
| DBPROP_ABORTPRESERVE | DBPROP_IRowsetScroll |
| DBPROP_ACCESSORDER | DBPROP_IRowsetUpdate |
| DBPROP_ACTIVESESSIONS | DBPROP_IRowsetView |
| DBPROP_ALTERCOLUMN | DBPROP_IScopedOperations |
| DBPROP_APPENDONLY | DBPROP_ISequentialStream |
| DBPROP_ASYNCTXNABORT | DBPROP_IStorage |
| DBPROP_ASYNCTXNCOMMIT | DBPROP_IStream |
| DBPROP_AUTH_CACHE_AUTHINFO | DBPROP_ISupportErrorInfo |
| DBPROP_AUTH_ENCRYPT_PASSWORD | DBPROP_IViewChapter |
| DBPROP_AUTH_INTEGRATED | DBPROP_IViewFilter |
| DBPROP_AUTH_MASK_PASSWORD | DBPROP_IViewRowset |
| DBPROP_AUTH_PASSWORD | DBPROP_IViewSort |
| DBPROP_AUTH_PERSIST_ENCRYPTED | DBPROP_LITERALBOOKMARKS |
| DBPROP_AUTH_PERSIST_SENSITIVE_AUTHINFO | DBPROP_LITERALIDENTITY |
| DBPROP_AUTH_USERID | DBPROP_LOCKMODE |
| DBPROP_BLOCKINGSTORAGEOBJECTS | DBPROP_MAXINDEXSIZE |
| DBPROP_BOOKMARKINFO | DBPROP_MAXOPENCHAPTERS |
| DBPROP_BOOKMARKS | DBPROP_MAXOPENROWS |
| DBPROP_BOOKMARKSKIPPED | DBPROP_MAXORSINFILTER |
| DBPROP_BOOKMARKTYPE | DBPROP_MAXPENDINGROWS |
| DBPROP_BYREFACCESSORS | DBPROP_MAXROWS |
| DBPROP_CACHEDEFERRED | DBPROP_MAXROWSIZE |
| DBPROP_CANFETCHBACKWARDS | DBPROP_MAXROWSIZEINCLUDESBLOB |
| DBPROP_CANHOLDROWS | DBPROP_MAXSORTCOLUMNS |
| DBPROP_CANSCROLLBACKWARDS | DBPROP_MAXTABLESINSELECT |
| DBPROP_CATALOGLOCATION | DBPROP_MAYWRITECOLUMN |
| DBPROP_CATALOGTERM | DBPROP_MEMORYUSAGE |
| DBPROP_CATALOGUSAGE | DBPROP_MULTIPLECONNECTIONS |
| DBPROP_CHANGEINSERTEDROWS | DBPROP_MULTIPLEPARAMSETS |
| DBPROP_CLIENTCURSOR | DBPROP_MULTIPLERESULTS |
| DBPROP_COL_AUTOINCREMENT | DBPROP_MULTIPLESTORAGEOBJECTS |
| DBPROP_COL_DEFAULT | DBPROP_MULTITABLEUPDATE |
| DBPROP_COL_DESCRIPTION | DBPROP_NOTIFICATIONGRANULARITY |
| DBPROP_COL_FIXEDLENGTH | DBPROP_NOTIFICATIONPHASES |
| DBPROP_COL_INCREMENT | DBPROP_NOTIFYCOLUMNSET |
| DBPROP_COL_ISLONG | DBPROP_NOTIFYROWDELETE |
| DBPROP_COL_NULLABLE | DBPROP_NOTIFYROWFIRSTCHANGE |
| DBPROP_COL_PRIMARYKEY | DBPROP_NOTIFYROWINSERT |
| DBPROP_COL_SEED | DBPROP_NOTIFYROWRESYNCH |
| DBPROP_COL_UNIQUE | DBPROP_NOTIFYROWSETCHANGED |
| DBPROP_COLUMNDEFINITION | DBPROP_NOTIFYROWSETFETCHPOSITIONCHANGE |
| DBPROP_COLUMNLCID | DBPROP_NOTIFYROWSETRELEASE |
| DBPROP_COLUMNRESTRICT | DBPROP_NOTIFYROWUNDOCHANGE |
| DBPROP_COMMANDTIMEOUT | DBPROP_NOTIFYROWUNDODELETE |
| DBPROP_COMMITPRESERVE | DBPROP_NOTIFYROWUNDOINSERT |
| DBPROP_COMSERVICES | DBPROP_NOTIFYROWUPDATE |
| DBPROP_CONCATNULLBEHAVIOR | DBPROP_NULLCOLLATION |
| DBPROP_CONNECTIONSTATUS | DBPROP_OLEOBJECTS |
| DBPROP_CURRENTCATALOG | DBPROP_OPENROWSETSUPPORT |
| DBPROP_DATASOURCENAME | DBPROP_ORDERBYCOLUMNSINSELECT |
| DBPROP_DATASOURCEREADONLY | DBPROP_ORDEREDBOOKMARKS |
| DBPROP_DATASOURCE_TYPE | DBPROP_OTHERINSERT |
| DBPROP_DBMSNAME | DBPROP_OTHERUPDATEDELETE |
| DBPROP_DBMSVER | DBPROP_OUTPUTENCODING |
| DBPROP_DEFERRED | DBPROP_OUTPUTPARAMETERAVAILABILITY |
| DBPROP_DELAYSTORAGEOBJECTS | DBPROP_OUTPUTSTREAM |
| DBPROP_DSOTHREADMODEL | DBPROP_OWNINSERT |
| DBPROP_FILTERCOMPAREOPS | DBPROP_OWNUPDATEDELETE |
| DBPROP_FINDCOMPAREOPS | DBPROP_PERSISTENTIDTYPE |
| DBPROP_GENERATEURL | DBPROP_PREPAREABORTBEHAVIOR |
| DBPROP_GROUPBY | DBPROP_PREPARECOMMITBEHAVIOR |
| DBPROP_HETEROGENEOUSTABLES | DBPROP_PROCEDURETERM |
| DBPROP_HIDDENCOLUMNS | DBPROP_PROVIDERFRIENDLYNAME |
| DBPROP_IAccessor | DBPROP_PROVIDERMEMORY |
| DBPROP_IBindResource | DBPROP_PROVIDERFILENAME |
| DBPROP_IChapteredRowset | DBPROP_PROVIDEROLEDBVER |
| DBPROP_IColumnsInfo | DBPROP_PROVIDERVER |
| DBPROP_IColumnsInfo2 | DBPROP_QUICKRESTART |
| DBPROP_IColumnsRowset | DBPROP_QUOTEDIDENTIFIERCASE |
| DBPROP_IConnectionPointContainer | DBPROP_REENTRANTEVENTS |
| DBPROP_IConvertType | DBPROP_REMOVEDELETED |
| DBPROP_ICreateRow | DBPROP_REPORTMULTIPLECHANGES |
| DBPROP_IDBAsynchStatus | DBPROP_RESETDATASOURCE |
| DBPROP_IDENTIFIERCASE | DBPROP_RETURNPENDINGINSERTS |
| DBPROP_IGetRow | DBPROP_ROW_BULKOPS |
| DBPROP_IGetSession | DBPROP_ROWRESTRICT |
| DBPROP_IGetSourceRow | DBPROP_ROWSET_ASYNCH |
| DBPROP_ILockBytes | DBPROP_ROWSETCONVERSIONSONCOMMAND |
| DBPROP_IMMOBILEROWS | DBPROP_ROWTHREADMODEL |
| DBPROP_IMultipleResults | DBPROP_SCHEMATERM |
| DBPROP_INDEX_AUTOUPDATE | DBPROP_SCHEMAUSAGE |
| DBPROP_INDEX_CLUSTERED | DBPROP_SERVERCURSOR |
| DBPROP_INDEX_FILLFACTOR | DBPROP_SERVERDATAONINSERT |
| DBPROP_INDEX_INITIALSIZE | DBPROP_SERVERNAME |
| DBPROP_INDEX_NULLCOLLATION | DBPROP_SESS_AUTOCOMMITISOLEVELS |
| DBPROP_INDEX_NULLS | DBPROP_SKIPROWCOUNTRESULTS |
| DBPROP_INDEX_PRIMARYKEY | DBPROP_SORTONINDEX |
| DBPROP_INDEX_SORTBOOKMARKS | DBPROP_SQLSUPPORT |
| DBPROP_INDEX_TEMPINDEX | DBPROP_STRONGIDENTITY |
| DBPROP_INDEX_TYPE | DBPROP_STRUCTUREDSTORAGE |
| DBPROP_INDEX_UNIQUE | DBPROP_SUBQUERIES |
| DBPROP_INIT_ASYNCH | DBPROP_SUPPORTEDTXNDDL |
| DBPROP_INIT_BINDFLAGS | DBPROP_SUPPORTEDTXNISOLEVELS |
| DBPROP_INIT_CATALOG | DBPROP_SUPPORTEDTXNISORETAIN |
| DBPROP_INIT_DATASOURCE | DBPROP_TABLESTATISTICS |
| DBPROP_INIT_GENERALTIMEOUT | DBPROP_TABLETERM |
| DBPROP_INIT_HWND | DBPROP_TBL_TEMPTABLE |
| DBPROP_INIT_IMPERSONATION_LEVEL | DBPROP_TRANSACTEDOBJECT |
| DBPROP_INIT_LCID | DBPROP_UNIQUEROWS |
| DBPROP_INIT_LOCATION | DBPROP_UPDATABILITY |
| DBPROP_INIT_LOCKOWNER | DBPROP_USERNAME |
| DBPROP_INIT_MODE | MDPROP_AGGREGATECELL_UPDATE |
| DBPROP_INIT_OLEDBSERVICES | MDPROP_AXES |
| DBPROP_INIT_PROMPT | MDPROP_FLATTENING_SUPPORT |
| DBPROP_INIT_PROTECTION_LEVEL | MDPROP_MDX_CASESUPPORT |
| DBPROP_INIT_PROVIDERSTRING | MDPROP_MDX_DESCFLAGS |
| DBPROP_INIT_TIMEOUT | MDPROP_MDX_FORMULAS |
| DBPROP_IParentRowset | MDPROP_MDX_JOINCUBES |
| DBPROP_IRow | MDPROP_MDX_MEMBER_FUNCTIONS |
| DBPROP_IRowChange | MDPROP_MDX_NONMEASURE_EXPRESSIONS |
| DBPROP_IRowSchemaChange | MDPROP_MDX_NUMERIC_FUNCTIONS |
| DBPROP_IRowset | MDPROP_MDX_OBJQUALIFICATION |
| DBPROP_IRowsetBookmark | MDPROP_MDX_OUTERREFERENCE |
| DBPROP_IRowsetChange | MDPROP_MDX_QUERYBYPROPERTY |
| DBPROP_IRowsetCurrentIndex | MDPROP_MDX_RANGEROWSET |
| DBPROP_IRowsetFind | MDPROP_MDX_SET_FUNCTIONS |
| DBPROP_IRowsetIdentity | MDPROP_MDX_SLICER |
| DBPROP_IRowsetIndex | MDPROP_MDX_STRING_COMPOP |
| DBPROP_IRowsetInfo | MDPROP_NAMED_LEVELS |
| DBPROP_IRowsetLocate | MDPROP_VISUALMODE |
| DBPROP_IRowsetRefresh |
1998-2001 Microsoft Corporation. All rights reserved.