Problem Database Connection Import

[Max_]

Hello

 

I am trying to import connections to an MySQL/ODBC database

 

The export of the connection works fine. But when i try to import the just exported file again i get the following error message: Unable to access database.

 

ODBC Log:

[1064] Driver error: 37000

[MySQL][ODBC 8.0(w) Driver][mysqld-8.0.20]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 '[000_u_fixture_configuration]' at line 1

 

Thanks in advance

 

Max

 

VWX 2020 SP3.1 Build 537701 (64bit)

DBConnections.xml

[BizGoz]

I ran into the same error message when trying to add in a database. Would be interested in if this was resolved.

[Marc Davies]

ODBC is really difficult to useconsistently at the moment. Can you export to SQLite instead? This seems to work best on a Mac as it avoids ODBC connectors, however, I don't know about a PC I'm afraid.

[Marc Davies]

Another thought which has given me problems in the past, which you may already know, but anything is worth a try... Make sure your primary key field definitely has only unique values as it trips up everything if there are two records with the same key value.