MDAC 2.5 SDK - OLE DB Providers
OLE DB Provider for SQL Server
SQLOLEDB interprets OLE DB session properties as described in the following table.
| Property ID | Description |
| DBPROP_SESS_AUTOCOMMITISOLEVELS | SQLOLEDB supports all auto-commit transaction isolation levels, with the exception of the chaos level, DBPROPVAL_TI_CHAOS. |
In the provider-specific property set DBPROPSET_SQLSERVERSESSION, SQLOLEDB defines the additional session property described in the following table.
| 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. |