troubleshooting Question

Unable to connect to any of the specified MySQL hosts --in VB.NET

Avatar of KennethSumerford1
KennethSumerford1Flag for United States of America asked on
MySQL Server.NET Programming
28 Comments1 Solution6304 ViewsLast Modified:
I have tried about 2 hours to resolve this problem, which was not a problem about 10 days ago.  In VB.NET and VS 2008, the  VB.NET cannot find the MySQL DB.  Below is a connection string that does Not work but should work.  The program and DB are on my local PC running Windows 7.

Dim connStr As String = "Database=faith7;Data Source=localhost;User Id=faith7DB1;Password=kxxxxxxx"

    Try
        Dim dbconn1 As New MySqlConnection
         dbconn1.ConnectionString = connStr

          dbconn1.Open()

The error is always:  
  Unable to connect to any of the specified MySQL hosts.

How can I fix this?
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 28 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 28 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros