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"
Dim dbconn1 As New MySqlConnection
dbconn1.ConnectionString = connStr
The error is always:
Unable to connect to any of the specified MySQL hosts.
How can I fix this?