Connecting to MySQL from ADO in VB

[markmercer]

I am trying to connect to an online MySQL database from VB6 using ADO
and I'm getting the following error. "data source name not found and no default driver specified"

here's the code I'm using to try to connect.

        Set conn = New ADODB.Connection
    Set rs = New ADODB.Recordset
    connectionstring = "Driver={MySQL ODBC 5.1 Driver};Data Source=URL,3306;Database=DBNAME;User=USERID; Password=PASS;Option=3;"
    conn.Open connectionstring
    rs.Open "SELECT * FROM card_prices", conn

no doubt its simply my inexperience with this type of connection. I have plenty of experience with MySQL but none with these connection string jiggys.

P.S. I've tried downloading the MySQL ODBC 5.1 Driver and installed it but no effect. Do I have to install the version matching my system or the one matching the server?