Forum Discussion
Solved
Cannot connect to local MySQL database.
Hi All, I press get data and select MySQL datatabase. I get the following message: "we encountered an error while trying to connect. the connector cannot be used because you are missing one ...
sois Ignore that link and instead download x64 bit MySQL connector and install yourself. I have seen before where doing that has fixed the problem.
I downloaded the mysql connector from next url:
https://dev.mysql.com/downloads/connector/odbc/
Please select for windows and 64 bit.
It works for me.
It turns out that the version is of the MySQL connector is very important. I wasted a lot of time trying to figure out why earlier versions -- some of them linked to in forums -- did not work.
For me this version only works, the new versions do not work at all
