Supported OLE DB Properties

Important

This feature will be removed in a future version of Windows. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Instead, write a fully functional OLE DB provider using the native OLE DB interfaces.

Supported Data Source Information Properties

Property	Default value
DBPROP_ACTIVESESSIONS	0
DBPROP_BYREFACCESSORS	VARIANT_FALSE
DBPROP_DATASOURCENAME	OSP Data Object ProgID
DBPROP_DATASOURCEREADONLY	VARIANT_FALSE
DBPROP_DSOTHREADMODEL	DBPROPVAL_RT_FREE
DBPROP_INIT_ASYNCH	0 Supported as READONLY because initialization of the data source object is always synchronous and immediate.
DBPROP_MAXROWSIZE	0
DBPROP_MULTIPLERESULTS	DBPROP_MR_NOTSUPPORTED
DBPROP_PERSISTENTIDTYPE	DBPROPVAL_PT_PROPID
DBPROP_PROVIDERFILENAME	Msdaosp.dll
DBPROP_PROVIDERFRIENDLYNAME	"Microsoft OLE DB Simple Provider"
DBPROP_PROVIDEROLEDBVER	02.00
DBPROP_PROVIDERVER	02.00xxxx
DBPROP_SQLSUPPORT	DBPROPVAL_SQL_NONE
DBPROP_TABLETERM	Data Member

Supported Initialization Properties

Property	Default value
DBPROP_INIT_DATASOURCE	OSP Data Object ProgID
DBPROP_INIT_LCID	LCID corresponding to the string returned by OLEDBSimpleProvider::getLocale

Supported Rowset Properties

Property	Default value
DBPROP_BOOKMARKS	VARIANT_TRUE
DBPROP_BOOKMARKSKIPPED	VARIANT_TRUE
DBPROP_BOOKMARKTYPE	DBPROPVAL_BMK_NUMERIC
DBPROP_CACHEDEFERRED	VARIANT_FALSE
DBPROP_CANFETCHBACKWARDS	VARIANT_TRUE
DBPROP_CANHOLDROWS	VARIANT_TRUE
DBPROP_CANSCROLLBACKWARDS	VARIANT_TRUE
DBPROP_CHANGEINSERTEDROWS	VARIANT_TRUE
DBPROP_COLUMNRESTRICT	OSPStatusRW When an OSP contains a read-only rowset (that is, getRWStatus() returns OSP_READONLY for all rows and columns), Msdaosp.dll sets properties DBPROP_ROWRESTRICT and DBPROP_COLUMNRESTRICT to VARIANT_TRUE. This reflects the possibility that the OSP might still allow new rows to be added, and these new rows might be updatable. If a new, updatable row is added, columns might have mixed write status.
DBPROP_DEFERRED	VARIANT_TRUE
DBPROP_FINDCOMPAREOPS	DBPROPVAL_CO_CONTAINS | DBPROPVAL_CO_BEGINSWITH | DBPROPVAL_CO_EQUALITY | DBPROPVAL_CO_STRING | DBPROPVAL_CO_CASESENSITIVE | DBPROPVAL_CO_CASEINSENSITIVE
DBPROP_IAccessor	VARIANT_TRUE
DBPROP_IColumnsInfo	VARIANT_TRUE
DBPROP_IColumnsRowset	VARIANT_FALSE
DBPROP_IConnectionPointContainer	VARIANT_TRUE
DBPROP_IConvertType	VARIANT_TRUE
DBPROP_IDBAsyncStatus	VARIANT_TRUE
DBPROP_IRowset	VARIANT_TRUE
DBPROP_IRowsetChange	VARIANT_TRUE
DBPROP_IRowsetFind	VARIANT_TRUE
DBPROP_IRowsetIdentity	VARIANT_TRUE
DBPROP_IRowsetInfo	VARIANT_TRUE
DBPROP_IRowsetLocate	VARIANT_TRUE
DBPROP_IRowsetResynch	VARIANT_FALSE
DBPROP_IRowsetScroll	VARIANT_TRUE
DBPROP_IRowsetUpdate	VARIANT_FALSE
DBPROP_ISupportErrorInfo	VARIANT_TRUE
DBPROP_IMMOBILEROWS	VARIANT_TRUE
DBPROP_LITERALBOOKMARKS	VARIANT_FALSE
DBPROP_LITERALIDENTITY	VARIANT_TRUE
DBPROP_MAXOPENROWS	0
DBPROP_MAXROWS	0
DBPROP_NOTIFICATIONGRANULARITY	DBPROPVAL_NT_MULTIPLEROWS
DBPROP_NOTIFICATIONPHASES	DBPROPVAL_NP_ABOUTTODO | DBPROPVAL_NP_SYNCHAFTER | DBPROPVAL_NP_DIDEVENT | DBPROPVAL_NP_FAILEDTODO | DBPROPVAL_NP_OKTODO
DBPROP_NOTIFYCOLUMNSET	0
DBPROP_NOTIFYROWDELETE	0
DBPROP_NOTIFYROWFETCHPOSITIONCHANGE	0
DBPROP_NOTIFYROWINSERT	0
DBPROP_NOTIFYROWSETRELEASE	0
DBPROP_ORDEREDBOOKMARKS	VARIANT_FALSE
DBPROP_OTHERINSERT	VARIANT_TRUE
DBPROP_OTHERUPDATEDDELETE	VARIANT_TRUE
DBPROP_OWNINSERT	VARIANT_TRUE
DBPROP_OWNUPDATEDELETE	VARIANT_TRUE
DBPROP_QUICKRESTART	VARIANT_TRUE
DBPROP_REENTRANTEVENTS	VARIANT_FALSE
DBPROP_REMOVEDELETED	VARIANT_TRUE
DBPROP_REPORTMULTIPLECHANGES	VARIANT_FALSE
DBPROP_ROWRESTRICT	OSPStatusRW
DBPROP_ROWSET_ASYNCH	DBPROPVAL_ASYNCH_SEQUENTIALPOPULATION Default value is (DBPROPVAL_ASYNCH_INITIALIZE | DBPROPVAL_ASYNCH_SEQUENTIALPOPULATION | DBPROPVAL_ASYNCH_RANDOMPOPULATION) Supported as READWRITE, but population of the rowset is determined by the underlying OSP by using the OLEDBSimpleProvider::isAsync method. Unless the underlying OSP is asynchronous, setting property DBPROP_ROWSET_ASYNCH will have no effect. Msdaosp.dll will not return until the rowset is populated.
DBPROP_ROWTHREADMODEL	DBPROPVAL_RT_FREE
DBPROP_STRONGIDENTITY	VARIANT_FALSE
DBPROP_UPDATABILITY	DBPROPVAL_UP_INSERT | DBPROPVAL_UP_CHANGE | DBPROPVAL_UP_DELETE