Loading
Feature Disruption - Service Cloud VoiceRead More
Feature degradation | Gmail Email delivery failureRead More

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

Publish Date: Feb 25, 2025
Description
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)

Cause

The computer running Tableau Server cannot establish a connection to the MySQL database.
Resolution
Install the latest version of MySQL driver from Tableau's Drivers page.

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.
Knowledge Article Number

001473905

 
Loading
Salesforce Help | Article