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 |