[FAQ000194]I am trying to connect to MySQL using ODBC and register data using an action, but an error occurs when executing the action

Q

I am trying to connect to MySQL using ODBC and register data using an action, but I get the following error when executing the action.

SQLActionError: Error occurred while processing database.

01000: Call to XObj.Open failed: Exception (0x80004005 Unspecified error) thrown from Microsoft OLE DB Provider for ODBC Drivers: Transaction cannot have multiple recordsets with this cursor type. Change the cursor type, commit the transaction, or close one of the recordsets.

A

If the version of the installed ODBC driver for MySQL (Connector/ODBC) is 8.0.33 or higher,

the following operation may cause an error.

• Execute the 'Import data of CSV file to table' action
• Batch execution of insert/update/delete data actions with the 'Batch execution of data updates' action

Therefore, if you use the above actions, please use Connector/ODBC version 8.0.32 or lower.

* If you use actions to insert, update, and delete data without using the 'Batch execution of data updates' action, there is no problem to use 8.0.33 or higher version.

* This incident has been confirmed to occur in versions 8.0.33 to 8.0.35, but it may be addressed in future updates.

Related keywords

Connect to external database, driver