Attribute

BatchFailureReturnsError (BFRE)

Purpose

Determines the behavior of the driver when encountering an error in a parameter array insert with bulk load disabled (EnableBulkLoad=0). Note that this option applies only when operating in autocommit mode.

Valid Values

0 | 1

Behavior

If set to 1 (Enabled), the driver returns SQL_ERROR and rolls back the operation when encountering an error in any of the parameter sets.

If set to 0 (Disabled), the driver returns SQL_SUCCESS_WITH_INFO and commits the rows that were successfully inserted prior to encountering the error.

Default

0 (Disabled)

GUI Tab

Advanced tab