mysql - 'You have a usable connection already' error in Visual Studio 2015 adding Data Source

Question

Visual Studio 2015; Windows 10;

In the Data Source Configuration Wizard, trying to add a table from a MySQL install on the network. I get up to this step

When I click 'Finish', I then get this error message:

Other SO posts refer to this issue, none are resolved. This is a fresh WinForms project, there is no code written.

Answer 1

I found a workaround on the MySQL Connector forums (http://forums.mysql.com/read.php?174,648619,649199#msg-649199)

Basically, you want to use Connector 6.9.8, not 6.9.9. So uninstall 6.9.9, install 6.9.8 from https://downloads.mysql.com/archives/c-net/

You can keep using MySQL 1.2.6 for Visual Studio. I will add this note:

Important

Always install MySQL for Visual Studio before installing MySQL Connector/Net.

From: https://dev.mysql.com/doc/visual-studio/en/visual-studio-install.html#Requirements in case you are reinstalling everything.