Connection failed to MySQL via ADO dsn-less connection string

Data Abstract
1

How do I connect to MySQL via ADO using DSN-less connection string?

Here is my connection string:
ADO?AuxDriver=MSDASQL.1;Server=localhost;Database=test;UserID=root;Password=yourpassword;Extended Properties=“DRIVER={MySQL ODBC 5.1 Driver};PORT=3306;OPTION=4212739”;

Please help.

2

Your ConnectionString should look like this:

ADO?AuxDriver=MSDASQL.1;Extended Properties=“DRIVER=MySQL ODBC 5.1 Driver;SERVER=localhost;DATABASE=test;UID=root;PWD=yourpassword;”

Best regards

3

Elenap:
I’ve tried your suggested connection string but still got an error.

ADO?AuxDriver=MSDASQL.1;Extended Properties=“DRIVER=MySQL ODBC 5.1 Driver;SERVER=localhost;DATABASE=test;UID=root;PWD=password”

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.

4

Hello,

You should use Winter 2011 DA, it doesn’t work with Fall 2011.

Hope this helps.