DBPROP_JETOLEDB_BULKNOTRANSACTIONS

Type: VT_I4

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.

DBPROP_JETOLEDB_BULKPARTIAL

Type: VT_I4

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.

DBPROP_JETOLEDB_ENABLEFATCURSOR

Type: VT_BOOL

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.

DBPROP_JETOLEDB_FATCURSORSMAXROWS

Type: VT_I4

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.

DBPROP_JETOLEDB_LOCKGRANULARITY

Type: VT_I4

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.

DBPROP_JETOLEDB_ODBCPASSTHROUGH

Type: VT_BOOL

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.

DBPROP_JETOLEDB_ODBCPASSTHROUGHCONNECTSTRING

Type: VT_BSTR

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.

DBPROP_JETOLEDB_STOREDQUERY

Type: VT_BOOL

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.

DBPROP_JETOLEDB_VALIDATEONSET

Type: VT_BOOL

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.