how to manually access MySQL using VB6?

how can i access Mysql using VB6?

i've installed all needed softwares to connect to MySQL...

i'v often seen this line of code to access mysql, but the problem is it returns me an error saying "User-defined type not defined"

____________
Dim conn As Adodb.Connection <------- these lines do returns
Dim rs As Adodb.Recordset <------ the error message

Set conn = New Adodb.Connection
conn.CursorLocation = adUseclient
conn.ConnectionString = "DRIVER={MySQL ODBC 3.51 Driver};" _
& "SERVER=localhost;" _
& "DATABASE=test_database;" _
& "UID=root;" _
& "PWD=;" _
& "OPTION="

conn.Open
Set rs = New Adodb.Recordset
rs.Open "SELECT * FROM table1", conn, adOpenStatic, adLockReadOnly
-------------------------



pls help...

thanks in advance...

Perhaps you need to install Microsoft's MDAC too. www.microsoft.com/data

Plz download the MDAC2.8 from download.microsoft.com...It's necessary to connect database use adodb object..