Edit

Session Properties - SQL Server Native Client OLE DB provider

  • Article

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

Important

The SQL Server Native Client (often abbreviated SNAC) has been removed from SQL Server 2022 (16.x) and SQL Server Management Studio 19 (SSMS). Both the SQL Server Native Client OLE DB provider (SQLNCLI or SQLNCLI11) and the legacy Microsoft OLE DB Provider for SQL Server (SQLOLEDB) are not recommended for new development. Switch to the new Microsoft OLE DB Driver (MSOLEDBSQL) for SQL Server going forward.

The SQL Server Native Client OLE DB provider interprets OLE DB session properties as follows.

Property ID Description
DBPROP_SESS_AUTOCOMMITISOLEVELS The SQL Server 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 SQL Server 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.

See Also

Data Source Objects (OLE DB)