This is a "Public Safety" application that I am attempting to migrate to Windows 7 from Windows XP.
I am getting the message: "unable to connect to any of the specified mysql hosts" from a Visual Studio 2010 C# (GUI) application on a Windows 7 (64) computer.
The app connects to the mySQL database just fine from Windows XP 32 bit.
Things I have tried on the Win7 computer:
1) installed the MySQL Connector 6.7.4 and Visual Studio 1.0.2 using the MySQL Installer
2) created a basic GUI forms VS 2010 project to only test a mySQL connection
3) tried a reference to MySQL.Data.dll version 6.7.4 for .net 4.0
4) tried a reference to MySQL.Data.dll version 6.7.4 for .net 2.0
5) tried your nifty code here(
http://dev.mysql.com/doc/refman/5.6/en/connector-net-tutorials-intro.html ) in a basic console application -- it also errors out with "Unable to connect to any of the specified MySQL hosts."
... no matter what I try I always get "Unable to connect to any of the specified MySQL hosts".
Can someone provide some assistance?