Re: OpenDatabase Method in VBA fails

[Alexandre Lopes]

First, add references to "Microsoft ActiveX Data Objects 2.x Library";
Second, use:

Dim db As New ADODB.Connection
Dim Rs As New ADODB.Recordset
Dim connString As String
conString = "DSN=myDsnName;DESC=Learning with Alexandre;DATABASE=myDatabase;SERVER=mydb.servername.com.br(or IP);UID=root;PASSWORD=myPassword;PORT=xxxx;OPTION=x;STMT=;"
db.Open connString, "root", "myPassword"
Rs.ActiveConnection = db
Rs.Source = "select * from myTable"
Rs.Open
MsgBox Rs(0)
Rs.Close

Good luck :)
Alexandre Lopes GEsTaPO