Loading

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

Publiseringsdato: Feb 25, 2025
Beskrivelse
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.
Løsning
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-artikkelnummer

001473905

 
Laster
Salesforce Help | Article