Hello,
I am trying to export to an external database (MySQL) but received the following error:
Type # Time Message
-1 1 4/20/2016 4:45 1 PM Document 1: Exporting document to 'Export to data files (Valid)'.
-1 2 4/20/2016 4:45 5 PM Document 1: Exporting document to 'Export to ODBC-compatible database'.
-1 3 4/20/2016 4:45:47 PM Document 1: Export to ODBC-compatible database: [MySQL][ODBC 5.3(w) Driver][mysqld-5.7.12-log]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(auto)' at line 1
I have used the latest version of ODBC connector.
The following is the error from the logs of ODBC driver.
1461167143:SELECT TABLE_NAME, TABLE_COMMENT, TABLE_TYPE, TABLE_SCHEMA FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = DATABASE() AND ( TABLE_TYPE='BASE TABLE' OR TABLE_TYPE='VIEW' ) AND TABLE_NAME LIKE 'LineItems';
1461167147:select * from European_Order (auto);
1461167147:Using direct execution;
1461167147:query has been executed;
1461167147:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(auto)' at line 1;
1461167147:ROLLBACK;
I am trying to export to an external database (MySQL) but received the following error:
Type # Time Message
-1 1 4/20/2016 4:45 1 PM Document 1: Exporting document to 'Export to data files (Valid)'.
-1 2 4/20/2016 4:45 5 PM Document 1: Exporting document to 'Export to ODBC-compatible database'.
-1 3 4/20/2016 4:45:47 PM Document 1: Export to ODBC-compatible database: [MySQL][ODBC 5.3(w) Driver][mysqld-5.7.12-log]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(auto)' at line 1
I have used the latest version of ODBC connector.
The following is the error from the logs of ODBC driver.
1461167143:SELECT TABLE_NAME, TABLE_COMMENT, TABLE_TYPE, TABLE_SCHEMA FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = DATABASE() AND ( TABLE_TYPE='BASE TABLE' OR TABLE_TYPE='VIEW' ) AND TABLE_NAME LIKE 'LineItems';
1461167147:select * from European_Order (auto);
1461167147:Using direct execution;
1461167147:query has been executed;
1461167147:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(auto)' at line 1;
1461167147:ROLLBACK;
コメント
3件のコメント
Could you please specify Flexicapture version and MySQl version?
Regards
Timur
MySQL Server 5.7
MySQL Connector Net 6.9.8
Sorry for late response.
This issue requires deep investigation.
Please try contacting abbyy support to resolve this issue:support@abbyy.com
Regards
Tim
サインインしてコメントを残してください。