Hello,

This is my way that i use for my application using Mysql database :

- you need to install Mysql Connector ( you can download in mysql.com)
- you can use Mysql Connection string (check here: www.connectionstrings.com)

and than you can use ADODB, same like you use to Connect into SQL Server or MS Access, but just change connection string with mysql connection string like the link i give you.