VB Code:
  1. Dim connMySQL As ADODB.Connection
  2.  
  3. Set connMySQL = New ADODB.Connection
  4.  
  5. Call connMySQL.Open("Provider=MySQLProv;Data Source=Data;User Id=root;Password=grb")
  6.  
  7. ...

The rest of the code is no need cause the problem is on the connection.