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:
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()