企业架构师-用于ODBC驱动程序的Microsoft OLE DB提供程序-2147217900/'80040E14' [英] Enterprise Architect - Microsoft OLE DB Provider for ODBC Drivers -2147217900 / '80040E14'

问题描述

我正在使用以下方法将Sparx的Enterprise Architect设置为以集中模式工作:

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

• EA版本10.0.1007
• 数据库:MySQL CE版本5.6.13.1
• 连接器:mysql-connector-odbc-5.3.2-win32.msi

我已经成功地在数据源"中设置了数据库和连接器.测试连接正常.

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

在第一个项目中，EA请求导入项目，在该项目中，我从C:\ Program Files(x86)\ Sparx Systems \ EA导入了EABase.eap.这也是成功.

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.

我单击从模式添加新模型"，选择名称"，然后单击确定"，然后出现以下错误(显示3次):

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

如果我关闭EA然后重新打开，则程序包和图表仍然存在，这意味着它们已保存到MySQL数据库中.

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.

如何解决这个问题?

推荐答案

将某些项目从eap文件迁移到MySQL数据库时，我遇到了相同的错误.

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

问题是由Cast(Partition as Signed);

Enterprise Architect使用列名"分区"，但这是自5.6.2版本以来的保留关键字(请参见

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.

切换到MySQL版本5.5.46(x64)，错误将消失.

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

这篇关于企业架构师-用于ODBC驱动程序的Microsoft OLE DB提供程序-2147217900/'80040E14'的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！