Oninit
Talk to an expert →

Informix Error -11007: Option value changed.

Cause and resolution

Option value changed.

The driver did not support the specified value of the VParam argument with the SQLSetConnectOption or SQLSetStatementOption. The driver substitutes a similar value and returns SQL_SUCCESS_WITH_INFO. To determine the new value of VParam, use SQLGetConnectionOption or SQLGetStatement.

This Informix CLI error code is the same as SQLSTATE value 01S02. The following functions can return this error code: SQLSetConnectOption() and SQLSetStmtOption().

The function returned SQL_SUCCESS_WITH_INFO, which means that the function completed successfully, and that a nonfatal error occurred. The nonfatal error occurred because Informix CLI does not support the vParam value for the option. The function substituted a similar value. For more information, call SQLError().

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-11007 fires when SQLSetConnectOption()/SQLSetStmtOption() receives an unsupported option value — per the official guidance, this is the same as SQLSTATE value 01S02.

  1. The driver not supporting the specified VParam value, per the official guidance — the driver substitutes a similar value and returns SQL_SUCCESS_WITH_INFO rather than failing outright.
Solutions / Resolution
  1. Call SQLGetConnectOption()/SQLGetStmtOption() to determine the substituted value, per the official guidance.
Examples
N/A

No specific triggering statement is documented beyond an unsupported option value.

Diagnostic Checks
  1. Call the matching SQLGet*Option() function to confirm what value the driver actually applied.
Related Errors / Related Topics

No closely related error codes are cross-referenced for -11007 in this set yet.

The driver substituted a similar value for an unsupported option setting — call the matching SQLGet*Option() function to see what was actually applied.