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.
Comments
5 comments
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.
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.
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
Hello
ABBY do SQL Server para ABBY?
How can I connect Abbyy that is on Server1 to the Sql Server that is on Server2?
Hello,
Could you please describe your scenario in more details?
Please sign in to leave a comment.