MDAC 2.5 SDK - OLE DB Providers
OSP Toolkit
| 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 |