Error Messages/43122

Example error message

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

Causes

Empty SQL

This error is encountered when the SQL parameter to DbQuery is empty text, "".

Microsoft description

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

(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.

See Also

• DbQuery
• DbQuery/Step-by-Step querying Microsoft Access
• Querying Access database from Analytica 64
• Database access
• Database functions