ole db提供程序 mysql,Enterprise Architect-用于ODBC驱动程序的Microsoft OLE DB提供程序-2147217900 /'80040E14'...

I am setting up Sparx's Enterprise Architect to work in centralized mode using:

EA version 10.0.1007

Database: MySQL CE version 5.6.13.1

Connector: mysql-connector-odbc-5.3.2-win32.msi

I've successfully setup the database and connector in Data Sources. Test connection is working.

On the first project, EA requesting to import project, in which I imported EABase.eap from C:\Program Files (x86)\Sparx Systems\EA. This is success also.

I click the Add New Model from Pattern, choose the Name, and click OK, then I got the following error (shown three times):

If I close the EA and then reopen, the packages and diagrams are still there, meaning they are saved to MySQL database.

The error is also shown whenever I first clicked on the diagram.

How to solve this problem?

解决方案

I had the same error while I migrated some projects from eap files to a MySQL database.

The problem is caused by Cast(Partition as Signed);

The Enterprise Architect uses a column name "Partition" but it is a reserved key word since version 5.6.2 (see the manual) of the MySQL dbms.

Switch to the MySQL version 5.5.46 (x64) and the error will disappear.