Informix Error -11416: Cannot set Standard ODBC Types only to ON when LO Automatic option is OFF.
Cause and resolution
Cannot set Standard ODBC Types only to ON when LO Automatic option is OFF.
This Informix ODBC error code is the same as SQLSTATE value S1000. The following functions can return this error code: SQLSetStmtAttr and SQLSetConnectAttr.
Turn the SQL_INFX_LO_AUTOMATIC_ATTR on first before turning the SQL_INFX_ATTR_ODBC_TYPES_ONLY on for a statement or connection.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-11416 fires when turning on SQL_INFX_ATTR_ODBC_TYPES_ONLY while
SQL_INFX_LO_AUTOMATIC_ATTR is still off — per the official guidance, this is the same as
SQLSTATE value S1000, returnable by SQLSetStmtAttr and SQLSetConnectAttr.
SQL_INFX_LO_AUTOMATIC_ATTRstill off while attempting to turn onSQL_INFX_ATTR_ODBC_TYPES_ONLY, per the official guidance — the direct, only cause; the two attributes have a dependency order.
Solutions / Resolution
- Turn
SQL_INFX_LO_AUTOMATIC_ATTRon first, per the official guidance, before turningSQL_INFX_ATTR_ODBC_TYPES_ONLYon.
Examples
N/A
No specific triggering statement is documented beyond turning the attributes on in the wrong order.
Diagnostic Checks
- Check the current state of both
SQL_INFX_LO_AUTOMATIC_ATTRandSQL_INFX_ATTR_ODBC_TYPES_ONLY, and set them in the required order.
Related Errors / Related Topics
- -11415 — "Cannot set LO Automatic option OFF when Standard ODBC Types only is ON." The mirror-image ordering restriction, for turning the attributes off rather than on.
- -11422 — "Smart large objects can only be used by setting SQL_INFX_ATTR_LO_AUTOMATIC." A related restriction on the same attribute, about it being required for smart-large-object use at all.
SQL_INFX_ATTR_ODBC_TYPES_ONLY can't be turned on while SQL_INFX_LO_AUTOMATIC_ATTR is
still off — turn that one on first.