Para conectarse a esta, es necesario bajar un DRIVER ODBC desde la Pagina de MySQL
aqui la URL
MySQL :: MySQL Connector/ODBC
Una vez Instalado (Next o Siguiente a todo) ya tendremos el Proveedor instalado
Código PHP:
Dim cn As Connection
Dim rs As Recordset
Private Sub Form_Load()
Const strServidor = "localhost"
Const strBaseDatos = "basededatos"
Const strPassword = "mypassword"
Const strUsuario = "root"
Set cn = New Connection
cn.ConnectionString = "DRIVER={MySQL ODBC 3.51 Driver}; SERVER=" & strServidor & _
"; DATABASE=" & strBaseDatos & _
"; User=" & strUsuario & _
"; Password=" & strPassword & "; OPTION=3"
cn.Open
Set rs = New Recordset
rs.Open "select * from Tabla", cn, adOpenStatic
Me.Caption = rs.Fields(0).Value
cn.Close
End Sub