unable to connect to any of the specified mysql hosts
Posted by: Steve Pospisil
Date: September 27, 2013 05:23AM


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 My connection string is also like this "Database=xxxxx;Data Source=localhost;Port=3306;User Id=xxx;password=xxx;pooling=false;"


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

Options: ReplyQuote

Written By
unable to connect to any of the specified mysql hosts
September 27, 2013 05:23AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.