unable to connect to any of the specified mysql hosts

[Steve Pospisil]

Hi,

I am having trouble with a process in my software application as it relates to maintaining a connection. I have a process that loops through each policy record in my database doing various data updates for each record. Randomly I will get an "unable to connect to any of the specified mysql hosts" error when doing one of those updates.

I only get this error when I run the process on my client's server. When I run the process locally on my machine within the Visual Studio IDE I do not get this error and everything is just fine.

I will point out that my client is currently running this process against another MySQL database in the same MySQL instance without any issues so I'm not sure why I'm getting this error.

I am using VB.NET and ADO.Net driver for MySQL version 6.5.4.0. My connection string is also like this "Database=xxxxx;Data Source=localhost;Port=3306;User Id=xxx;password=xxx;pooling=false;"

Thanks.



Edited 1 time(s). Last edit at 09/27/2013 05:55AM by Steve Pospisil.