Visual Studio - 无法将 MySql 数据库表链接到 DataSet [英] Visual Studio - Failed to link MySql database table to DataSet

问题描述

当我在服务器资源管理器中成功添加与数据库的连接后尝试将 MySQL 表拖到 DataSet 时，我收到两条错误消息，一个接一个:

When I try to drag a MySQL table to a DataSet after successfully adding a connection to a database in Server Explorer, I receive two error messages, one after the other:

"部分更新命令无法自动生成.数据库返回以下错误:意外错误."

"Some updating commands could not be generated automatically. The database returned the following error: Unexpected error."

"鼠标拖动操作失败.无法检索表或视图的架构信息."

"Mouse drag operation failed. Could not retrieve schema information for table or view."

根据类似问题的答案，我重新安装了'MySqlConnector/Net'和'MySql for Visual Studio'，同样的问题依然存在.我想知道出了什么问题.

Based on answers for similiar problems, I reinstalled 'MySqlConnector/Net' and 'MySql for Visual Studio', and the same problem persists. I would like to know what is going wrong.

推荐答案

我找到了解决方案.经过数小时的修修补补，我发现当前版本的 MySql-for-visual-studio 和 MySqlConnector/Net 有一个错误，只能通过卸载它们并安装 MySQL-for-visual-studio- 来修复1.2.6.msi 和 MySqlConnector-6.9.8.msi，完全按照这个顺序.

I found the solution. After hours and hours of tinkering I found out that the current versions of MySql-for-visual-studio and MySqlConnector/Net have a bug, which can only be fixed by unninstalling those and installing MySQL-for-visual-studio-1.2.6.msi and MySqlConnector-6.9.8.msi, exactly in this order.

这篇关于Visual Studio - 无法将 MySql 数据库表链接到 DataSet的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！