Have you tested on a DBMS MySQL 8 repository?

[Mauricio Moya (Arquesoft)]

I have created a MySQL 8 repository but when users connected to the repository it throws database errors for every update/insert action that users execute in the user interface.

Do you think this is a problem related to the MySQL version? or could it be another weird missconsideration (as the Cloud Server config).

The environment is:
MySQL 8
ODBC driver 32 bits
Cloud server
Server contains: MySQLServer, Cloud Server, ODBC, Keystore server
Final users: EA 14.1 + TOGAF MDG. Floating licenses.

[Eve]

Sounds like you didn't check 'Return matched rows instead of affected rows'

See https://sparxsystems.com/enterprise_architect_user_guide/14.0/model_repository/setupmysqlodbcdriver.html

[Mauricio Moya (Arquesoft)]

I think it is checked (I usually don't forget to check the both options for mysql).

In another test, I had some issues when reverse engineering a mysql database. After several tests, I have just concluded that EA 14.1 does not work with MySQL 8 (in DB schema import from ODBC).

Tomorrow I will test the checks you said and with an older MySQL version (5.x)

[Mauricio Moya (Arquesoft)]

Today I tested on a MySQL 5.7.23 (with the suitable checks in the 32 bits ODBC connection) and it still fails. The ODBC driver I'm using is version 8.0.

[Sunshine]

Today I tested on a MySQL 5.7.23 (with the suitable checks in the 32 bits ODBC connection) and it still fails. The ODBC driver I'm using is version 8.0.

It states the following in the user guide -have you tried reading it?
A machine with MySQL version 5 or higher installed and running,
MySQL 32bit ODBC driver, between versions 5.2.4 and 5.3.6 (other versions are not recommended)

https://sparxsystems.com/enterprise_architect_user_guide/14.0/model_repository/upsizingtomysql.html