Export (0) Print
Expand All

Session Properties

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.

Community Additions

ADD
Show:
© 2014 Microsoft