Export (0) Print
Expand All

Supported OLE DB Properties

Important note 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.

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

Property

Default value

DBPROP_INIT_DATASOURCE

OSP Data Object ProgID

DBPROP_INIT_LCID

LCID corresponding to the string returned by OLEDBSimpleProvider::getLocale

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

Show:
© 2015 Microsoft