Supported OLE DB Properties

[This is preliminary documentation and subject to change.]

The OLE DB properties in this table are supported by Index Server. Other properties are not supported. Refer to the OLE DB Programmer's Reference for a complete description of these properties.

Property Settable Default
DBPROP_BLOCKINGSTORAGEOBJECTS FALSE VARIANT_FALSE
DBPROP_BOOKMARKS TRUE VARIANT_TRUE if the rowset is locatable.
DBPROP_BOOKMARKSKIPPED FALSE VARIANT_FALSE
DBPROP_BOOKMARKTYPE FALSE Bookmarks are DBPROPVAL_BMK_NUMERIC
DBPROP_CANFETCHBACKWARDS FALSE VARIANT_FALSE
DBPROP_CANHOLDROWS TRUE VARIANT_TRUE if the rowset is locatable
DBPROP_CANSCROLLBACKWARDS FALSE VARIANT_TRUE if the rowset is locatable
DBPROP_COLUMNRESTRICT FALSE VARIANT_FALSE
DBPROP_COMMANDTIMEOUT TRUE The default is 0, which means no timeout.
DBPROP_LITERALBOOKMARKS FALSE VARIANT_FALSE
DBPROP_LITERALIDENTITY FALSE VARIANT_TRUE if the rowset is locatable
DBPROP_MAXOPENROWS FALSE The default is 0, which means no limit.
DBPROP_MAXROWS TRUE The default is 0, which means no limit.
DBPROP_MEMORYUSAGE TRUE The default is 0, which means no limit. Not implemented.
DBPROP_ORDEREDBOOKMARKS FALSE VARIANT_TRUE if the rowset is locatable
DBPROP_OTHERINSERT FALSE VARIANT_TRUE if the rowset is asynchronous
DBPROP_OTHERUPDATEDELETE FALSE VARIANT_TRUE if the rowset is asynchronous
DBPROP_QUICKRESTART FALSE VARIANT_TRUE if the rowset is locatable
DBPROP_REENTRANTEVENTS FALSE VARIANT_FALSE
DBPROP_REMOVEDELETED FALSE VARIANT_TRUE
DBPROP_ROWRESTRICT FALSE VARIANT_TRUE
DBPROP_ROWTHREADMODEL FALSE The default is DBPROPVAL_RT_FREETHREAD.
DBPROP_SERVERCURSOR FALSE VARIANT_TRUE
DBPROP_STRONGIDENTITY FALSE VARIANT_TRUE if the rowset is locatable
DBPROP_UPDATABILITY FALSE The default is 0, which means updates aren't supported.