string connection = "Provider=MySQLProv;DRIVER={MySQL ODBC 3.51 Driver};SERVER=localhost;DATABASE=test;USER=wey;PASSWORD=wey;OPTION=3;"; ...
I just installed MySQL ODBC/Connector (tried both 3.5 and 5.1 for Intel - no difference) and set up tested a mySQL server, but Excel 2008 (12.1.2)on my 10.5.4 based Mac keeps saying "No ODBC Driver is ...