无法在vb数据源中添加mysql db表 [英] cann't add mysql db table in vb datasource
问题描述
在此处输入图片描述我在Windows 10中安装了带有视觉效果的mysql 8.0.3 studio2017.我在mysql中创建了数据库和表,但是当我想通过VB Windows窗体应用程序在数据源中添加它时,出现此错误
enter image description hereI installed mysql 8.0.3 in windows 10 with visual studio 2017. I created DB and table in mysql but when I want to add it through VB Windows form App in data source I got this error
Could not retrieve schema information for table or view `testtable`.
我可以从服务器资源管理器选项卡中添加它,并且测试连接正常.
I can added it from server explorer tab and test connection is OK.
要解决此问题,我该怎么做?
What I have to do to solve this issue?
感谢所有人
推荐答案
问题已解决!
整个问题出在连接器上.但不仅卸载并重新安装都可以解决问题.
The whole problem is from connector. but not only uninstalled and reinstalled will solve the issue.
我要做的是去
C:\Program Files (x86)\Microsoft Visual Studio 14.0\Common7\IDE\PrivateAssemblies
并删除MySql.Data.dll文件,然后为mysql 5.7安装mysql-connector-net-6.9.8
and delete MySql.Data.dll file then installed mysql-connector-net-6.9.8 for mysql 5.7
这是通过深入的故障排除最终解决了我的问题的方法.
this is what finally solved my problem with deeply troubleshooting.
感谢所有在这里
这篇关于无法在vb数据源中添加mysql db表的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!