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
