Sparx Systems Forum
Enterprise Architect => Bugs and Issues => Topic started by: GarethI on May 09, 2018, 09:12:02 pm
-
Looking for some guidance as this is the first time I've attempted to setup a remote DB for sharing a project. I've got:
- MariaDB instance (10.1.32) - Loaded with EASchema_1220_MySQL.sql - updated the zero timestamps with NOW()
- MariaDB 32 bit driver 3.0.3 - Set "Enable automatic Reconnect" & "Return matched rows instead of affected rows"
- Sparx 14.0.1418 - Corporate Edition
When attempting to transfer a project (passes the integrity check) there is an SQL syntax error on t_xref. I couldnt figure out how to attach a screenshot, so below is my transcribed version of the error
[ma-3.03][10.1.32-MariaDB] You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'Partition,Description,Client,Supplier) VALUES (?,?,?,?,?,?,?,?)' at line 1
[Select * from t_xref]
Field: link
Press OK to continue to next row (this record will be lost), Cancel to abort
---
Although logging for the transfer was on some additional details are below:
2018-05-09 10:49:34 Copying project information for: t_constrainttypes
ERROR: An error has occurred:
Microsoft OLE DB Provider for ODBC Drivers [-2147217900]
[ma-3.0.3][10.1.32-MariaDB]You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'Constraint,Description,Notes) VALUES (?,?,?)' at line 1
ERROR: An error has occurred:
Microsoft OLE DB Provider for ODBC Drivers [-2147217900]
[ma-3.0.3][10.1.32-MariaDB]You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'Constraint,Description,Notes) VALUES (?,?,?)' at line 1
ERROR: An error has occurred:
Microsoft OLE DB Provider for ODBC Drivers [-2147217900]
[ma-3.0.3][10.1.32-MariaDB]You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'Constraint,Description,Notes) VALUES (?,?,?)' at line 1
--
Any guidance would be greatly appreciated,
Gareth
-
MySQL ODBC Connector 5.3.4 works.
-
Many thanks yes I ended up using 5.3.10 (mysql-connector-odbc-5.3.10-win32.msi) as that was what I could download and that worked a treat.
I've not tried 8 (Connector/ODBC 8.0.11), but I'll update the community with the results for completeness.