Issue:

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...

 

Solution:

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

https://www.microsoft.com/en-us/download/details.aspx?id=40784

Then install the MySql driver.

 

Important note: The Redistributables need to be the “for visual studio” not the standard redistributables.