wish help you to fix your issue Yes you can use MySQL to drive a website using ASP.NET or any other web development technology for that matter. The reason for choosing SQL Server over MySQL would if there were features or performance characteristics you wanted in SQL Server that did not exist in MySQL. For example, common-table expressions do not exist in MySQL. If there are no features in either that are driving your decision, then it comes down to personal preference and cost.
Can't connect to MySQL databse of any webhost from anywhere other than the webhost itself
hop of those help? So after we discussed your Problem a long way I will write an Answer: Please do not call your webservice via IP, always take the URL (especially when you have a webhoster) Always check your PHP Script via a Browser on your PC, you will see the errors directly. Debug the errors shown by your php script
Hope that helps Please download the suitable driver from following link. You have to download the driver for operating system from which you are trying to connect.Inyour case this is windows. Mysql Driver for windows.
C# Use/connect to MySQL database in webhost (One.com)