Mysql Connector For Visual Studio 2010
Thank you for your reply. The MySQL instance is running and I have downloaded MySQL Workbench and it works fine connecting to the database.
Mysql Connector For Visual Studio 2013
With some debugging, I have figured out that there is a MySQLException. The code is1042: Unable to connect to host.
I'm not sure what that means. I have looked at many threads, most outdated, and none have a definate solution. It must be a VS problem since Workbench is working. I assume if it was a MySQL problem thenI would be getting the same error in Workbench. Sankarsan Parida, I did try your post and it still got the same error. MySQL Server is running when I try to connect to it.
At each reboot of my system, I run the mysqld.exe in the bin directory of the MySQL Server which is supposed to startthe server. I test this by running Workbench and all is well there. I am wondering if VS is having problems because I did not run the server as a Windows service. Does anyone know if this may be the problem?
If so, I guess I will bereinstalling the MySQL server.
As someone else suggests.fixes the problem.I had v6.2.3 installed after I had vs2010 installed and the MySQL driver was not shown in the list of the Database Connect dialog. I wrongly assumed I should use the.NET ODBC drivers instead and it caused all sorts of problems. Although I could easily connect to the DB using codebehind, the server explorer wouldn’t connect to the DB.Luckily after uninstalling 6.2.3 and installing 6.3.0 (from the link above) the MySQL driver was added to VS2010, and I was able to connect to the database and see it in my server explorer.