vba with mysql retrive data

[nag rajuu]

hi

i am connecting to mysql database using VBA.

i am new to VBA i tried like this

Dim oConn As ADODB.Connection
Dim rs As ADODB.Recordset
Dim rsc As ADODB.Recordset
Dim strsql as String

Set oConn = New ADODB.Connection
oConn.Open "DRIVER={MySQL ODBC 5.1 Driver};" & _
"SERVER=localhost;" & _
"DATABASE=tamp;" & _
"USER=root;" & _
"PASSWORD=test;" & _
"Option=3"
strsql = "SELECT * from info"
rs.Open strsql, oConn, adOpenStatic, adLockOptimistic

i got error upto this code

my intention is to display the info table data .

please guide me how to retrieve the data from info table.

any one guide me