troubleshooting Question

MySQL connection failing in Vista & VS2005

Avatar of bhermer
bhermer asked on
.NET ProgrammingASP.NET
10 Comments1 Solution880 ViewsLast Modified:

I have been using VS2005 under XP pro fine.

I have just upgraded to Vista (downgraded maybe ;))  and I have opened one of my 'Working' websites that uses MySQL, using reference to the MySQL 1.08 ASP Connector.

I get the following error (btw I can connect to the DB fine through my DBtools DB manager software and the command promt so I know the DB is fine)

Unable to connect to any of the specified MySQL hosts

An example of the code is the following:

Imports MySql.Data.MySqlClient

 Public Shared Function CreateDataSet(ByVal SQL As String)
        Dim myConnection As New MySqlConnection("server=localhost; user id=root; password=******; database=aa; pooling=false;")
        Dim myCommand As New MySqlCommand(SQL, myConnection)
        Dim myAdapter As New MySqlDataAdapter(myCommand)
        Dim ds As New DataSet()
        Return ds
    End Function


Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 10 Comments.
Start Free Trial
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 10 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