{var%20f='http://v.t.sina.com.cn/share/share.php?appkey=1515056452',u=z||d.location,p=['&url=',e(u),'&title=',e(t||d.title),'&source=',e(r),'&sourceUrl=',e(l),'&content=',c||'gb2312','&pic=',e(p||'')].join('');function%20a(){if(!window.open([f,p].join(''),'mb',['toolbar=0,status=0,resizable=1,width=440,height=430,left=',(s.width-440)/2,',top=',(s.height-430)/2].join('')))u.href=[f,p].join('');};if(/Firefox/.test(navigator.userAgent))setTimeout(a,0);else%20a();})(screen,document,encodeURIComponent,'','','https://www.manongdao.com/data/attach/logo/logo.png', '推荐 Evening l夕情丶 的问题《Visual Studio - Failed to link MySql database tabl》','https://www.manongdao.com/q-370545.html','页面编码gb2312|utf-8默认gb2312'));){kind=link}
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.msiandMySqlConnector-6.9.8.msi, exactly in this order.This worked, except I had to install 1.2.7 before I could get MYSQL to show up as an option as data provider.