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

[David Wilks]

I may have a workaround for this problem.

When my connection string is set to pooling=false; then I get the same error after a few hundred calls to stored procedures using the connect-net interface. When, however, I change to pooling=true;, it runs like a champ.

I found that I must turn pooling off when using temporary tables because otherwise I get the error, "Table xxx already exists".

It would be great if anyone can tell me how to solve the temporary table issue while pooling=true. There is a reset connection method that would delete the temporary tables but I don't know how to call it, or if it can be called using the connector-net interface.