>Great resource for connection strings! Tried them all, none work. What is confusing is that the MySQL Workbench says its version 5.1.73. But under ODBCAD32.exe it shows "MySQL ODBC 5.3 ANSI (or UNICODE) driver". i.e. 5.3 ... I have tried with/without the word "ANSI", using versions 5.0, 5.1, 5.2, 5.3, with/without the "w", and with/without the "Provider". All return "Data source name not found and no default driver specified". Strange.

My favorite trick for weird connectstrings is to build a connection in whichever odbcAd there is and save it as a file DSN (actually there's no "save as", you have to start it as a File DSN... the GUI for it is prehistoric). Then open the .dsn file in a text editor - just replace carriage returns with semicolons and you got your connectstring.