| description | title | ms.custom | ms.date | ms.prod | ms.prod_service | ms.reviewer | ms.technology | ms.topic | helpviewer_keywords | ms.assetid | author | ms.author | monikerRange | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Session Properties - SQL Server Native Client OLE DB provider |
Session Properties OLE DB |
03/14/2017 |
sql |
database-engine, sql-database, sql-data-warehouse, pdw |
native-client |
reference |
|
2498fbad-b3db-4bea-8fc6-fef5317d3eba |
markingmyname |
maghan |
>=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current |
[!INCLUDESQL Server Azure SQL Database Synapse Analytics PDW ]
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. |