ENTERPRISE ARCHITECTDBMS Driver Issues
Over the years there have been numerous versions of particular database drivers that cause compatiblity issues with Enterprise Architect and the Pro Cloud Server. In most cases Sparx Systems has no control over these issues as the drivers are produced by 3rd parties, therefore the easiest solution is simply to avoid them.
Therefore Sparx Systems advises that all versions listed below should be avoided.
MariaDB / MySQL
| Version | Date Found | Observed Behavior |
| ODBC v8.0.26 | Mar-2022 |
When attempting to make database updates the following error occurs: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax" Reason: Sparx Systems believe this is caused by the ODBC driver incorrectly determining the current permissions, we suggest v8.0.25 or v8.0.28 should be used instead. |
| ODBC v5.3.7 to v5.3.9 | 2018 |
When used in Pro Cloud Server (PCS) the PCS service could terminate unexpectedly. see: MySQL bug report Reason: The MySQL ODBC driver was compiled as single threaded, which caused issues in the multi-thread PCS. |
| ODBC v5.3.5 to 5.3.14 | 2018 |
When used in Pro Cloud Server (PCS) the PCS service could terminate unexpectedly. An updated version of the MS Visual Studio redist are needed, check file: C:\Windows\SysWOW64\msvcr120.dll the version should be 12.0.40649.5 anything earlier will cause issues, download link. Reason: Sparx Systems believe the ODBC driver was going through a transitional period that used a different version of MS Visual Studio and the installer package wasn't updated to include the correct runtimes |
| ODBC v5.2.4 | 2013 | Assorted errors - don't use |
| ODBC v5.2.2 | 2012 | Assorted errors - don't use |
| ODBC v5.1.4 | 2008 | Assorted errors - don't use |
| ODBC v5.1.1 | 2008 | Assorted errors - don't use |
| ODBC v3.51.14 | 2007 | Assorted errors - don't use |
Microsoft Access (ACE)
| Version | Date Found | Observed Behavior |
| 16.0.4519.1000 | 2020 |
When attempting open a MS Access repository (particularly when using the 64bit version of Enterprise Architect) various errors could occur,
ranging from "required driver not installed" to EA crashing. Reason: For a period of time Microsoft stopped 3rd party applications (like Enterprise Architect) from being able to use the installed Access Control Entity (ACE) drivers, this was corrected in later builds. Sparx Systems has tested and confirmed that version 16.0.5044.1000 now functions as expected. The latest Microsoft Access Database Engine Redistributable can be found here. |
Oracle
No known issues.
MS SQL Server
No known issues.
PostgreSQL
| Version | Date Found | Observed Behavior |
| ODBC v9.3.0300 | Nov-2014 | A customer reported the ODBC Administrator crashed when using the PostgreSQL 9.3.0300 driver, when they reverted back to v9.2 the problem no longer occurred. |