mysql未能检索到表或视图,Visual Studio-无法将MySql数据库表链接到DataSet

最新推荐文章于 2022-05-27 22:38:24 发布

树叶航

最新推荐文章于 2022-05-27 22:38:24 发布

阅读量211

点赞数

文章标签： mysql未能检索到表或视图

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."

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.

解决方案

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.