How to connect VB with MySql

Hi ,
I would like to know how vb can be connected to MySql.I tried but didnt find any providers for MySql.Please help me
Stanly

You need to install the MySQL ODBC driver!
http://www.mysql.com/downloads/api-myodbc-3.51.html

Once you have the drivers installed here's a program with information on interfacing with the database (the code itself is with a access database but provides a mysql connection string example in the comments)

http://www.1337geek.com/code/vb6/database/ADODB/