Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Database error anyone help?
#1
Im trying to connect my vb.NET Application to my database witch is on my website. Im getting this error: 

"An unhandled exception of type 'MySql.Data.MySqlClient.MySqlException' occurred in MySql.Data.dll 

Additional information: Unable to connect to any of the specified MySQL hosts." 

The error is being called on "sconnection.open()" 

Ive searched google and i cant find whats wrong. My site is through Hosting24. Code: http://pastebin.com/Gd4JCakQ
Reply
#2
Hi sc2141, I just got the same error. Did you find a fix?
Reply
#3
Hello sc2142 and Bobadilla! Welcome to BP forums and thanks for posting.

Assuming that the MySQL host is properly setup with Hosting24 and that your connection string is correct, I think the most probable cause of this error is a lack of permission. Usually, MySQL databases only allow access to the database from the same machine that the database is running on.

That is to say, I believe this error is happening because your database does not allow connection from remote hosts.

What kind of control panel does Hosting24 give you? There should be a setting somewhere about MySQL remote connections, where you should whitelist access from either:
1. Your machine's IP address
2. All IP Addresses (0.0.0.0)

Hope this helps and keep us updated on your progress!
My Blog | My Setup | My Videos | Have a wonderful day.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)