KNOWLEDGE BASE

Error "[iODBC][Driver Manager]Data source name not found..." Connecting to Microsoft SQL Server on a Mac


Published: 25 Nov 2014
Last Modified Date: 16 May 2016

Issue

When you try to connect to Microsoft SQL Server from Tableau Desktop on a Mac, the following error might occur:
 
The drivers necessary to connect to this database server are not properly installed. Visit http://www.tableausoftware.com/drivers to download driver setup files.
[iODBC][Driver Manager]Data source name not found and no default driver specified. Driver could not be loaded.

Environment

  • Tableau Desktop 8.2
  • Mac OS
  • Microsoft SQL Server

Resolution

Step 1

Download and install the Microsoft SQL Server driver for the Mac. For more information, see Drivers & Activation on the Tableau website.

Step 2

Open the ODBC Administrator:
  1. Click on Finder.
  2. In the search box, type ODBC Administrator. If the ODBC Administrator is not found, navigate to the Utilities folder and locate the application.
  3. Double-click on ODBC Administrator.
  4. If the ODBC Administrator is not already installed on your computer, it can be downloaded from the following link: ODBC Administrator Tool for Mac OSX v1.0.

​Step 3

​​Configure the Driver:
  1. In the ODBC Administrator, select the Drivers tab.
  2. Click Add.
  3. In the Description section, enter Simba SQL Server ODBC Driver.
  4. Next to the Driver file field, click on Choose to browse to the correct driver file.
  5. Navigate to the location of the ‘libsimbasqlderverodbc.dylib’ file. The location should be similar to the following: /opt/simba/sqlserverodbc/lib/universal/libsimbasqlserverodbc.dylib
  6. Once located, click Choose.
  7. Under Define as select System.
  8. Click OK.
  9. Click Apply.

Cause

Tableau Desktop is unable to locate the driver necessary to make the data connection.

Additional Information

  • The folder where the driver is located might be hidden. For more information on showing hidden folders, see View Hidden Folders on your Mac Using Terminal at About Technology.
  • It is important to enter the Driver Description exactly as it appears in the instructions above.
Did this article resolve the issue?