Visual Studio-无法将MySql数据库表链接到DataSet [英] Visual Studio - Failed to link MySql database table to DataSet
问题描述
当我在Server Explorer中成功添加到数据库的连接后尝试将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屋!