On 64 bit machine using MySQL ODBC 5.1

Connection string

This MySQL Connector/ODBC 5.1 connection string can be used for connections to MySQL.

It seems we need to point on MSDASQL for the (32 bit) ODBC driver to work on 64 bit machines.

Provider=MSDASQL;Driver={MySQL ODBC 5.1 Driver};Server=localhost;
Database
=myDataBase;
User=myUsername;Password=myPassword;Option=3;