KNOWLEDGE BASE

Error "The Specified DSN contains an architecture mismatch..."


Published: 06 Aug 2013
Last Modified Date: 20 Feb 2014

Issue

The following error might occur when you try to publish to Tableau Server, refresh a data source, or view a workbook on Tableau Server:

com.tableausoftware.nativeapi.dll.DataSourceException: The drivers necessary to connect to the database server '<server name> are not properly installed on Tableau Server.
[Microsoft][ODBC Driver Manager] The Specified DSN contains an architecture mismatch between the Driver and Application
Unable to connect using the DSN named <DSN name>. Check that the DSN exists and is a valid connection.

Environment

  • Tableau Server
  • ODBC driver

Resolution

Option 1:

If you are using the generic ODBC driver and a native driver exists for the database, install the appropriate driver. For more information, see Tableau Drivers & Activation.

Option 2:

If you are using an unsupported database and no native driver exists for the database, follow the steps in the Get Started with Tableau and SAS section of the Connecting to SAS ODBC in Tableau article in the Tableau knowledge base.

Note: Tableau does not support generic ODBC driver connections that use an unsupported database.

Cause

A 64-bit version of odbcad32.exe has been used to create, configure, or remove a DSN that connects to a 32-bit driver, or a 32-bit version of odbcad32.exe has been used to create, configure, or remove a DSN that connects to a 64-bit driver.

Additional Information

For additional information regarding configuring a DSN in the ODBC Data Source Administrator, see ODBC Data Source Administrator in the Dev Center.
Did this article resolve the issue?