title: "Session Properties - SQL Server Native Client OLE DB provider | Microsoft Docs" ms.custom: "" ms.date: "03/14/2017" ms.prod: sql ms.prod_service: "database-engine, sql-database, sql-data-warehouse, pdw" ms.reviewer: "" ms.suite: "sql" ms.technology: native-client ms.tgt_pltfrm: "" ms.topic: "reference" helpviewer_keywords:
- "sessions [OLE DB]"
- "SQL Server Native Client OLE DB provider, sessions" ms.assetid: 2498fbad-b3db-4bea-8fc6-fef5317d3eba author: MightyPen ms.author: genemi manager: craigg monikerRange: ">=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017"
[!INCLUDEappliesto-ss-asdb-asdw-pdw-md] [!INCLUDESNAC_Deprecated]
The [!INCLUDEssNoVersion] Native Client OLE DB provider interprets OLE DB session properties as follows.
| Property ID | Description |
|---|---|
| DBPROP_SESS_AUTOCOMMITISOLEVELS | The [!INCLUDEssNoVersion] Native Client OLE DB provider 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 [!INCLUDEssNoVersion] Native Client OLE DB provider 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. |