1 of 1 people found this helpful
Translation of error:
"Unable to connect to the ODBC data source. Make sure the drivers are installed and the connection properties are valid." So it appears that the connection is being made through an ODBC connection and not a "native" connection (On a server >> MySQL) as below:
If you have an old version of MySQL you may need to install an earlier version of the driver.
I did use MySQL native connection.
The problem was indeed an incompatibility issue between MySQL version and ODBC drivers.
Thanks for your help !
Cool, glad you got it fixed
Instead of the latest version, I installed this:
And my problem is solved. I think Tableau drivers page should mention this for MySQL.
Thanks Joyo for the tip. This helped.
Another thing to add is that the 32bit version (mysql-connector-odbc-5.1.12-win32.msi) is the one to install even for 64bit Windows. It connected once I uninstalled 64bit and installed 32bit.