Properties (Alphabetical)

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.