Session Properties

SQLOLEDB interprets OLE DB session properties as follows.

Property ID Description
DBPROP_SESS_AUTOCOMMITISOLEVELS SQLOLEDB supports all autocommit transaction isolation levels with the exception of the chaos level, DBPROPVAL_TI_CHAOS.

In the provider-specific property set DBPROPSET_SQLSERVERSESSION, SQLOLEDB defines the following additional session property.

Property ID Description
SSPROP_QUOTEDCATALOGNAMES Type: VT_BOOL
R/W: Read/write
Default: VARIANT_FALSE
Description: Quoted identifiers allowed in CATALOG restriction.

VARIANT_TRUE:  Quoted identifiers are recognized for a catalog restriction for the schema rowsets that supply distributed query support.

VARIANT_FALSE:  Quoted identifiers are not recognized for a catalog restriction for the schema rowsets that supply distributed query support.

For more information about schema rowsets that supply distributed query support, see Distributed Query Support in Schema Rowsets.


  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.