Data Source Properties

SQLOLEDB implements data source properties as follows.

Property ID	Description
DBPROP_CURRENTCATALOG	R/W: Read/write Default: None Description: The value of DBPROP_ CURRENTCATALOG reports the current database for a SQLOLEDB session. Setting the property value has the identical effect as setting the current database by using the Transact-SQL USE database statement.
DBPROP_MULTIPLECONNECTIONS	R/W: Read/write Default: VARIANT_TRUE Description: If the connection is busy running a command that does not produce a rowset, or produces a rowset that is not a server cursor and you execute another command, then a new connection will be created to execute the new command if DBPROP_ MULTIPLECONNECTIONS is VARIANT_ TRUE. SQLOLEDB won’t create another connection if DBPROP_MULTIPLECONNECTION is VARIANT_FALSE or if a transaction is active on the connection. SQLOLEDB returns DB_E_OBJECTOPEN if DBPROP_ MULTIPLECONNECTIONS is VARIANT_FALSE and returns E_FAIL if there is an active transaction. Transactions and locking are managed by Microsoft® SQL Server™ on a per connection basis. If a second connection is generated, the commands on the separate connections do not share locks. Care must be taken to ensure that one command does not block another by holding locks on rows requested by the other command. Each session has a separate connection. The above is also true for creating multiple sessions.

Property ID

Description

DBPROP_CURRENTCATALOG

R/W: Read/write
Default: None
Description: The value of DBPROP_
CURRENTCATALOG reports the current database for a SQLOLEDB session. Setting the property value has the identical effect as setting the current database by using the Transact-SQL USE database statement.

DBPROP_MULTIPLECONNECTIONS

R/W: Read/write
Default: VARIANT_TRUE
Description: If the connection is busy running a command that does not produce a rowset, or produces a rowset that is not a server cursor and you execute another command, then a new connection will be created to execute the new command if DBPROP_
MULTIPLECONNECTIONS is VARIANT_
TRUE.

SQLOLEDB won’t create another connection if DBPROP_MULTIPLECONNECTION is VARIANT_FALSE or if a transaction is active on the connection. SQLOLEDB returns DB_E_OBJECTOPEN if DBPROP_
MULTIPLECONNECTIONS is VARIANT_FALSE and returns E_FAIL if there is an active transaction. Transactions and locking are managed by Microsoft® SQL Server™ on a per connection basis. If a second connection is generated, the commands on the separate connections do not share locks. Care must be taken to ensure that one command does not block another by holding locks on rows requested by the other command.

Each session has a separate connection. The above is also true for creating multiple sessions.

In the provider-specific property set DBPROPSET_SQLSERVERDATASOURCE, SQLOLEDB defines the following additional data source property.

Property ID	Description
SSPROP_ENABLEFASTLOAD	R/W: Read/write Default: VARIANT_FALSE Description: To bulk copy, SSPROP_ENABLEFASTLOAD property is set to VARIANT_TRUE. With this property set on the data source, the newly created session allows consumer access to the IRowsetFastLoad interface.