KNOWLEDGE BASE

Error "Unable to connect to the ODBC Data Source" Connecting to MySQL


Published: 24 Mar 2014
Last Modified Date: 20 Apr 2017

Issue

When you try to open views with MySQL connections or refresh extracts connected to MySQL, the following error might occur:

TableauException: Unable to connect to the ODBC Data Source. Check that the necessary drivers are installed and that the connection properties are valid. [MySQL][ODBC 5.2(w) Driver]Can't connect to MySQL server on '<IP>' (10060) Unable to connect to the server "<IP>". Check that the server is running and that you have access privileges to the requested database

When you try to connect directly to the same MySQL database with a MySQL Connector or a similar application from the computer running Tableau Server, the following error might occur:

Connection Failed: [HY000] [MySQL][ODBC 5.2(w) Driver]Can't connect to MySQL server on '<IP>' (10060)

Environment

  • Tableau Server
  • MySQL

Resolution

Work with your MySQL administrator and/or IT network administrator to ensure that the computer running Tableau Server is allowed to connect to the MySQL database.

If you have a distributed installation of Tableau Server, all computers running Tableau Server must be able to connect to the MySQL database.

Some common problems that prevent connection include:
  • A firewall on the computer running Tableau Server might prevent outgoing connections for MySQL port (default - 3306).
  • Problems with the Domain Name System (DNS).
  • MySQL database might be configured to accept connections only from certain IPs. In this case, the IP of the computer running Tableau Server should be in the list.

Cause

The computer running Tableau Server cannot establish a connection to the MySQL database.
Did this article resolve the issue?