Re: MySqlException: Unable to connect to any of the specified MySQL hosts

[mcleod]

I have the same problem, but only on one out of three machines that I use for testing. Two of them even have the same OS (Windows XP Pro, all updates).

The only apparent difference between their configurations is that on the one having problems MyOdbc is installed. Is any of you having trouble if MyODBC is NOT installed?
Maybe it conflicts with the connector?

The symptoms are exactly the same as explained by others: It works fine after a restart for about 40 connections to go and then it suddenly ends. It is not a problem of the MySql server, because the servers work fine with the other machines with the same connection strings. The problem is definitely in the Connector itself.

Changing from "localhost" to "ip" does not have any effect. In fact, the connection string is simply not the problem. It may be, in cases where you do have the wrong connection string, because MySql behaves exactly the same way as if it weren't there at all. If you remove all instances of MySql Server, you get the exact same error.

So if any one knows of a real solution, please let me know!

cheers,

Bart McLeod
[e-mail]