Unable to connect to any host of the specified MySql Host

Question

I developed the system using VB.NET and Mysql 5 and everything working perfectly.  Also my LAN works perfectly.

When developing the project I set the Copy Local property of the MySql.Data.dll reference to True.   Now I can deploy the MySql.Data.dll as a part of my application. All files in output folder.

Problem came when deploy to other machines in the LAN.

Error is: Unable to connect to any host of the specified MySql Host

I disable the firewall and check but the problem remain same. 

Connection String: "server=192.168.1.111;Database=mydatabase;userid=user;password=user;pooling=false"

Please direct me to overcome this situation

Thank you in advance

 

Answer 1

Please ensure the address and the port of your MySQL server, and check the network. I do not think it is a development issue. It is a network configuration issue. So please try to check it first. It is also not a .Net setup question. Be an off-topic.

Answer 2

Hi Leulae,

Since your question is not related with the .NET Framework setup, I move your post to off-topic forum.

You can find the MSDN Forum category at http://social.msdn.microsoft.com/Forums/en-US/categories

If you do not know where to post your question, you can get some suggestion at: http://social.msdn.microsoft.com/Forums/en-US/whatforum/threads

Since your issue is related with MySQL connection, you can also cotact Oracle for help: http://mysql.com/support/

Thanks for your understanding.

Best Regards,

---

Andrew Wu [MSFT]
MSDN Community Support | Feedback to us
Get or Request Code Sample from Microsoft
Please remember to mark the replies as answers if they help and unmark them if they provide no help.