MySql Connection [HELP]

[k3pos]

I need help in MYSQL connection,
I wrote this script and it say that it doesnt found the database.

Private Sub Form_Load()
 
Dim sConnect As ADODB.Connection
Dim sRecord As ADODB.Record
Dim sTrconnect As String
 
Set sConnect = New ADODB.Connection
Set sRecord = New ADODB.Record
 
sTrconnect = "Driver={mySQL};Server=84.95.241.143;Port=2222;Option=131072;Stmt=;Database=private_test;Uid=private_test;Pwd=private_test;"
sConnect.ConnectionString = sTrconnect
sConnect.Open
sRecord.Open ("select * from `test`")
 
Label1.Caption = sRecord("title") & sRecord("pass")
 
 
End Sub

What is the problem?


BTW : The space in the Uid section in the connection script doesnt exist in the real script

-k3pos