Publishing a MySql data source to Tableau server and trying to connect to this data source produces the error:
The drivers necessary to connect to the database server '%servername%' are not properly installed on Tableau Server. Visit http://www.tableau.com/drivers to download driver setup files. [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified Unable to connect to the server "%servername%". Check that the server is running and that you have access privileges to the requested database.
Installing the MySql driver then fails due to the following error:
Error 1918. Error installing ODBC driver MySQL ODBC
5.3 ANSI Driver, ODBC error 13: The setup routines for
the MySQL ODBC 5.3 ANSI Driver ODBC driver could
not be loaded due to system error code 126: The
specified module could not be found. ...\myodbc5S.dll...
MySQL Connector/ODBC requires Microsoft Visual C++ 2010 or 2013 redistributable so you have to install it first.
You can find Visual C++ Redistributable Packages for Visual Studio 2013 at
Then install the MySql driver.
Important note: The Redistributables need to be the “for visual studio” not the standard redistributables.