Error exporting to MySQL compatible database (MariaDB)

  • 403 Views
  • Last Post 29 November 2018
  • Topic Is Solved
Yehuda Goldenberg posted this 02 July 2018

I'm getting an error exporting data to MariaDB. The error shows up in the task log in the Processing Server Monitor. This is a distributed installation, FlexiCapture 12. I turned on the General Log on the database and I can see that the processing station is connecting to the database and running SQL queries. It inserts a record in the table and does a rollback. The error reported in the task log is: "Document 1: Export to ODBC-compatible database: Multiple-step operation generated errors. Check each status value."

It looks like it's reporting the exact error returned by the database in the task log. However when I manually run the same sql statements that I find in the general log I don't get any errors.

Order By: Standard | Newest | Votes
Yehuda Goldenberg posted this 02 July 2018

I tried creating a new project and a new export profile, and although it successfully creates the table in the database, the export fails with the following error:

Document 1: Export to Paradigm DB: Internal program error: Src\ADOExporter.cpp, 1771.

 

Ekaterina posted this 16 July 2018

Hello,

Please be sure that your database belongs to the supported database. See Installing and running the program > System requirements

Then address your issue to the regional support.

MAlabaster posted this 17 July 2018

I have connected to MySQL (read only) for the Invoice data sets. I used the Microsoft OLE DB provider for ODBC drivers and the connection string requires a special OPTION parameter to set ODBC compatiblity for MySQL, hope it works for you

Driver={MySQL ODBC 5.3 ANSI Driver};DATABASE=yourdbname;OPTION=134217728;PWD=yourpwd;UID=youruser;SERVER=YOURSERVER

Anibal posted this 22 November 2018

 Hello

ABBY do SQL Server para ABBY?

How can I connect Abbyy that is on Server1 to the Sql Server that is on Server2?

Ekaterina posted this 29 November 2018

Hello,

Could you please describe your scenario in more details?

Close