ADO Connection to a MySQL DB

I need a connection string for ADO to a MySQL database. This is what I pulled from another post but I get the No Default Driver Specified Error. I am new to the world of MySQL, I just need to connect and grab the contents of one table to compare to another in SQL Server 7.0. I have NO CLUE what the connection string should be...

VB Code:

Public Const gsConnection As String = "driver={MySQL};server=blah.blah.com;uid=uid;pwd=pwd;database=phpshop"

(Posted in Database Q&A as well)

not sure if u can use ADO with MySQL, ivbe never heard of it before!

Download and install MyODBC (Win32 version), and you can use that to connect to a local or remote MySQL via ADO. I had no problems running MySQL on a Linux box and connecting to it via VB/ADO on a Windows box (unfortunately I've misplaced my code...).