Session Properties - OLE DB Driver for SQL Server

Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (PDW)

Download OLE DB driver

The OLE DB Driver for SQL Server interprets OLE DB session properties as follows.

Property ID	Description
DBPROP_SESS_AUTOCOMMITISOLEVELS	The OLE DB Driver for SQL Server supports all autocommit transaction isolation levels with the exception of the chaos level DBPROPVAL_TI_CHAOS.

In the provider-specific property set DBPROPSET_SQLSERVERSESSION, the OLE DB Driver for SQL Server 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.
SSPROP_ALLOWNATIVEVARIANT	Type: VT_BOOL R/W: Read/Write Default: VARIANT_FALSE Description: Determines if the data fetched in is as DBTYPE_VARIANT or DBTYPE_SQLVARIANT. VARIANT_TRUE: Column type is returned as DBTYPE_SQLVARIANT in which case the buffer will hold SSVARIANT structure. VARIANT_FALSE: Column type is returned as DBTYPE_VARIANT and the buffer will have VARIANT structure.
SSPROP_ASYNCH_BULKCOPY	To use asynchronous mode, set the provider specific session property SSPROP_ASYNCH_BULKCOPY to VARIANT_TRUE before calling the BCPExec method. This property is available in the DBPROPSET_SQLSERVERSESSION property set.

See Also

Data Source Objects (OLE DB)