Supported OLE DB Properties

Following are the OLE DB properties supported by the OLE DB Simple Provider Toolkit. Because the Toolkit provides support for redistributable components, you may want to include this information along with the providers you build.

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_ASYNC	0
DBPROP_MAXROWSIZE	0
DBPROP_MULTIPLERESULTS	DBPROP_MR_NOTSUPPORTED
DBPROP_PERSISTENTIDTYPE	DBPROPVAL_PT_NAME
DBPROP_PROVIDERFRIENDLYNAME	"Microsoft OLE DB Simple Provider"
DBPROP_PROVIDERNAME	MSDAOSP.DLL
DBPROP_PROVIDEROLEDBVER	02.00
DBPROP_PROVIDERVER	02.00.xxx
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 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
DBPROP_DEFERRED		VARIANT_TRUE
DBPROP_FINDCOMPAREOPS	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_NOTIFYROWINSERT		0
DBPROP_NOTIFYROWSETRELEASE		0
DBPROP_NOTIFYROWFETCHPOSITIONCHANGE		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_INITIALIZE \| DBPROPVAL_ASYNCH_SEQUENTIALPOPULATION \| DBPROPVAL_ASYNCH_RANDOMPOPULATION
DBPROP_ROWTHREADMODEL		DBPROPVAL_RT_FREE
DBPROP_STRONGIDENTITY		VARIANT_FALSE
DBPROP_UPDATABILITY		DBPROPVAL_UP_INSERT \| DBPROPVAL_UP_CHANGE \| DBPROPVAL_UP_DELETE