MDAC 2.5 SDK - OLE DB Programmer's Reference
Appendix C: OLE DB Properties


 

Properties (Alphabetical)

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_IRowsetLocate
DBPROP_ACCESSORDER DBPROP_IRowsetRefresh
DBPROP_ACTIVESESSIONS DBPROP_IRowsetScroll
DBPROP_ALTERCOLUMN DBPROP_IRowsetUpdate
DBPROP_APPENDONLY DBPROP_IRowsetView
DBPROP_ASYNCTXNABORT DBPROP_IScopedOperations
DBPROP_ASYNCTXNCOMMIT DBPROP_ISequentialStream
DBPROP_AUTH_CACHE_AUTHINFO DBPROP_IStorage
DBPROP_AUTH_ENCRYPT_PASSWORD DBPROP_IStream
DBPROP_AUTH_INTEGRATED DBPROP_ISupportErrorInfo
DBPROP_AUTH_MASK_PASSWORD DBPROP_IViewChapter
DBPROP_AUTH_PASSWORD DBPROP_IViewFilter
DBPROP_AUTH_PERSIST_ENCRYPTED DBPROP_IViewRowset
DBPROP_AUTH_PERSIST_SENSITIVE_AUTHINFO DBPROP_IViewSort
DBPROP_AUTH_USERID DBPROP_LITERALBOOKMARKS
DBPROP_BLOCKINGSTORAGEOBJECTS DBPROP_LITERALIDENTITY
DBPROP_BOOKMARKINFO DBPROP_LOCKMODE
DBPROP_BOOKMARKS DBPROP_MAXINDEXSIZE
DBPROP_BOOKMARKSKIPPED DBPROP_MAXOPENCHAPTERS
DBPROP_BOOKMARKTYPE DBPROP_MAXOPENROWS
DBPROP_BYREFACCESSORS DBPROP_MAXORSINFILTER
DBPROP_CACHEDEFERRED DBPROP_MAXPENDINGROWS
DBPROP_CANFETCHBACKWARDS DBPROP_MAXROWS
DBPROP_CANHOLDROWS DBPROP_MAXROWSIZE
DBPROP_CANSCROLLBACKWARDS DBPROP_MAXROWSIZEINCLUDESBLOB
DBPROP_CATALOGLOCATION DBPROP_MAXSORTCOLUMNS
DBPROP_CATALOGTERM DBPROP_MAXTABLESINSELECT
DBPROP_CATALOGUSAGE DBPROP_MAYWRITECOLUMN
DBPROP_CHANGEINSERTEDROWS DBPROP_MEMORYUSAGE
DBPROP_CLIENTCURSOR DBPROP_MULTIPLECONNECTIONS
DBPROP_COL_AUTOINCREMENT DBPROP_MULTIPLEPARAMSETS
DBPROP_COL_DEFAULT DBPROP_MULTIPLERESULTS
DBPROP_COL_DESCRIPTION DBPROP_MULTIPLESTORAGEOBJECTS
DBPROP_COL_FIXEDLENGTH DBPROP_MULTITABLEUPDATE
DBPROP_COL_INCREMENT DBPROP_NOTIFICATIONGRANULARITY
DBPROP_COL_ISLONG DBPROP_NOTIFICATIONPHASES
DBPROP_COL_NULLABLE DBPROP_NOTIFYCOLUMNSET
DBPROP_COL_PRIMARYKEY DBPROP_NOTIFYROWDELETE
DBPROP_COL_SEED DBPROP_NOTIFYROWFIRSTCHANGE
DBPROP_COLUMNDEFINITION DBPROP_NOTIFYROWINSERT
DBPROP_COLUMNLCID DBPROP_NOTIFYROWRESYNCH
DBPROP_COLUMNRESTRICT DBPROP_NOTIFYROWSETCHANGED
DBPROP_COL_UNIQUE DBPROP_NOTIFYROWSETFETCHPOSITIONCHANGE
DBPROP_COMMANDTIMEOUT DBPROP_NOTIFYROWSETRELEASE
DBPROP_COMMITPRESERVE DBPROP_NOTIFYROWUNDOCHANGE
DBPROP_COMSERVICES DBPROP_NOTIFYROWUNDODELETE
DBPROP_CONCATNULLBEHAVIOR DBPROP_NOTIFYROWUNDOINSERT
DBPROP_CONNECTIONSTATUS DBPROP_NOTIFYROWUPDATE
DBPROP_CURRENTCATALOG DBPROP_NULLCOLLATION
DBPROP_DATASOURCENAME DBPROP_OLEOBJECTS
DBPROP_DATASOURCEREADONLY DBPROP_OPENROWSETSUPPORT
DBPROP_DATASOURCE_TYPE DBPROP_ORDERBYCOLUMNSINSELECT
DBPROP_DBMSNAME DBPROP_ORDEREDBOOKMARKS
DBPROP_DBMSVER DBPROP_OTHERINSERT
DBPROP_DEFERRED DBPROP_OTHERUPDATEDELETE
DBPROP_DELAYSTORAGEOBJECTS DBPROP_OUTPUTPARAMETERAVAILABILITY
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_SORTONINDEX
DBPROP_INDEX_PRIMARYKEY DBPROP_SQLSUPPORT
DBPROP_INDEX_SORTBOOKMARKS DBPROP_STRONGIDENTITY
DBPROP_INDEX_TEMPINDEX DBPROP_STRUCTUREDSTORAGE
DBPROP_INDEX_TYPE DBPROP_SUBQUERIES
DBPROP_INDEX_UNIQUE DBPROP_SUPPORTEDTXNDDL
DBPROP_INIT_ASYNCH DBPROP_SUPPORTEDTXNISOLEVELS
DBPROP_INIT_BINDFLAGS DBPROP_SUPPORTEDTXNISORETAIN
DBPROP_INIT_CATALOG DBPROP_TABLETERM
DBPROP_INIT_DATASOURCE DBPROP_TBL_TEMPTABLE
DBPROP_INIT_GENERALTIMEOUT DBPROP_TRANSACTEDOBJECT
DBPROP_INIT_HWND DBPROP_UNIQUEROWS
DBPROP_INIT_IMPERSONATION_LEVEL DBPROP_UPDATABILITY
DBPROP_INIT_LCID DBPROP_USERNAME
DBPROP_INIT_LOCATION MDPROP_AGGREGATECELL_UPDATE
DBPROP_INIT_LOCKOWNER MDPROP_AXES
DBPROP_INIT_MODE MDPROP_FLATTENING_SUPPORT
DBPROP_INIT_OLEDBSERVICES MDPROP_MDX_CASESUPPORT
DBPROP_INIT_PROMPT MDPROP_MDX_DESCFLAGS
DBPROP_INIT_PROTECTION_LEVEL MDPROP_MDX_FORMULAS
DBPROP_INIT_PROVIDERSTRING MDPROP_MDX_JOINCUBES
DBPROP_INIT_TIMEOUT MDPROP_MDX_MEMBER_FUNCTIONS
DBPROP_IParentRowset MDPROP_MDX_NONMEASURE_EXPRESSIONS
DBPROP_IRow MDPROP_MDX_NUMERIC_FUNCTIONS
DBPROP_IRowChange MDPROP_MDX_OBJQUALIFICATION
DBPROP_IRowSchemaChange MDPROP_MDX_OUTERREFERENCE
DBPROP_IRowset MDPROP_MDX_QUERYBYPROPERTY
DBPROP_IRowsetChange MDPROP_MDX_RANGEROWSET
DBPROP_IRowsetCurrentIndex MDPROP_MDX_SET_FUNCTIONS
DBPROP_IRowsetFind MDPROP_MDX_SLICER
DBPROP_IRowsetIdentity MDPROP_MDX_STRING_COMPOP
DBPROP_IRowsetIndex MDPROP_NAMED_LEVELS
DBPROP_IRowsetInfo