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.