Hello Experts, Hope All are doing good
Here is my question go though it!
We have created a web service with the .net framework ".asmx", and inside the web method we have some MySQL block that writs some data to the remotly connected DB. our database is Bitnami MySQL deployed on Microsoft Azure, when we run the .asmx page localy it runs without errors, but when we run it on Azure sometimes it works and most of times it returns this error:
MySql.Data.MySqlClient.MySqlException (0x80004005): Unable to connect to any of the specified MySQL hosts.
We use the latest MySQL .net connector and this is our connection string:
string MyConString = "user id=root;persistsecurityinfo=True;server=52.xxx.xx.xx;database=xxxxxxx;password='xxxxx';" ;
MySqlConnection connection = new MySqlConnection(MyConString);
MySqlCommand command = connection.CreateCommand();
command.CommandText = "INSERT INTO .........;";
In the time I write this the service runs well and return success but then it fails again, so what seems to be the problem? thank you in advance.