I have Visual Studio 2017 Community installed, and MySQL Community 8.0.12 on a same PC. It is also equipped with MySQL for Visual Studio 2.0.5 and MySQL Connector/NET 8.0.12.
Now, using the DataSource
Wizard in Visual Studio. I was able to test the connection to my server and select which Tables
that I wanted to add to the DataSet
.
However when I click Finish
, a following errors showed up:
"Some updating commands could not be generated automatically. The database returned the following error: Unexpected Error"
This is followed by another error log:
"Could not retrieve schema information for table or view [tablename]"
for every Table
I wanted to add.
I already looked up to some information regarding the said errors, but so far they are talking about older version of Visual Studio and MySQL. Any help will be appreciated. Thank you.