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:
  1. Public Const gsConnection As String = "driver={MySQL};server=blah.blah.com;uid=uid;pwd=pwd;database=phpshop"

(Posted in Database Q&A as well)