Provider-Specific Properties in DBPROPSET_JETOLEDB_ROWSET

Typical R/W: R/W

Description: Jet OLEDB:Bulk Transactions

Determines whether SQL bulk operations are transacted. This property determines whether the current command execution is transacted.

• DBPROPVAL_BT_DEFAULT—Defer to the value specified in DBPROP_JETOLEDB_GLOBALBULKTRANSACTIONS.
  
  
• DBPROPVAL_BT_NOBULKTRANSACTIONS—Bulk operations are not transacted.
  
  
• DBPROPVAL_BT_BULKTRANSACTIONS—Bulk operations are transacted.

Large bulk operations might fail when transacted due to resource limitations.

This property overrides the value set in DBPROP_JETOLEDB_GLOBALBUILDTRANSACTIONS.

Typical R/W: R/W

Description: Jet OLEDB:Partial Bulk Ops

This property determines the behavior of Jet when SQL DML operations fail.

• DBPROPVAL_BP_DEFAULT—Defer to the value of DBPROP_JETOLEDB_GLOBALBULKPARTIAL.
  
  
• DBPROPVAL_BP_PARTIAL—Allow partial completion of the bulk operation.
  
  
• DBPROPVAL_BP_NOPARTIAL—Fail the bulk operation on a single error.

Typical R/W: R/W

Description: Jet OLEDB:Enable Fat Cursors

This property indicates whether Jet should cache multiple rows when populating the cursor for remote row sources.

Typical R/W: R/W

Description: Jet OLEDB:Fat Cursor Cache Size

Number of rows that should be cached when using remote data store row caching. Used only if DBPROP_JETOLEDB_ENABLEFATCURSOR is VARIANT_TRUE.

Typical R/W: R/W

Description: Jet OLEDB:Locking Granularity

Determines whether a table is opened using Alcatraz row-level locking. This property is ignored unless DBPROP_JETOLEDB_DATABASELOCKMODE is set to DBPROPVAL_DL_ALCATRAZ.

• DBPROPVAL_LG_PAGE—Use page locking for this result set for concurrency control.
  
  
• DBPROVAL_LG_ALCATRAZ—Use row-level locking for concurrency control.

Typical R/W: R/W

Description: Jet OLEDB:ODBC Pass-Through Statement

This property tells Jet that SQL text in a Command object should be passed to the back end unaltered.

• VARIANT_TRUE—Pass SQL to remote connection.

VARIANT_FALSE—Interpret SQL statement locally.

Typical R/W: R/W

Description: Jet OLEDB:Pass Through Query Connect String

Jet connect string to be used to connect to the remote data store. This property is used with DPROP_JETOLEDB_ODBCPASSTHROUGH and is ignored unless the value for that property is VARIANT_TRUE.

Typical R/W: R/W

Description: Jet OLEDB:Stored Query

Whether the command text set in ICommandText::SetCommandText should be interpreted as a stored query instead of an SQL command. 

• VARIANT_TRUE—This is a stored query.
  
  
• VARIANT_FALSE—Use normal parsing to evaluate the query.

Typical R/W: R/W

Description: Jet OLEDB:Validate Rules On Set

Whether Jet Validation Rules are evaluated when columns are set or when changes are being committed to the database.

• VARIANT_TRUE—Validation Rules are evaluated when columns are set.
  
  
• VARIANT_FALSE—Validation Rules are evaluated only when changes are committed. In Delayed Update mode, this occurs when IRowsetUpdate::Update is called.