Error Messages/43122

Example Error Message

HY010:[Microsoft][ODBC Driver Manager] Function sequence error.

= Empty SQL

I encountered this error when the SQL parameter to DbQuery was empty text, "".

Microsoft description

Microsoft's documentation has this (cryptic) explanation of HY010:

(DM) An asynchronously executing function was called for a StatementHandle associated with the ConnectionHandle and was still executing when SQLDisconnect was called.

(DM) An asynchronously executing function (not this one) was called for the ConnectionHandle and was still executing when this function was called.

(DM) SQLExecute, SQLExecDirect, SQLBulkOperations, or SQLSetPos was called for a StatementHandle associated with the ConnectionHandle and returned SQL_NEED_DATA. This function was called before data was sent for all data-at-execution parameters or columns.