Error when creating a Linked Server with ODBC Drivers: "The specified DSN contains an architecture mismatch"

The error "The specified DSN contains an architecture mismatch" occurs due to a difference in architecture between the ODBC driver and SQL Server. 

To ensure proper operation of the Linked Server, the ODBC driver must be installed on the same machine where SQL Server is running.

If using SQL Server x64, make sure to specify a DSN with a 64-bit version of the ODBC driver when configuring the data source.

• Related Articles

• Error When Creating a Linked Server with ODBC Driver: "Data source name not found"

  The error "Data source name not found" typically indicates that Microsoft SQL Server is unable to locate or access the specified ODBC data source. To resolve this issue, make sure that: The ODBC driver is correctly installed on the same machine where ...

• Error 193 While Creating ODBC Connection in ODBC Administration

  If you encounter Error 193 while creating an ODBC connection, it's important to note that our ODBC drivers currently do not support Windows ARM. We are actively working on expanding compatibility and will provide updates on the possibility of ...

• Error "Cannot load client library: <path libs>" in Products: IBDAC, UniDAC (InterBase, FireBird), ODBC (InterBase, FireBird)

  Issue When working with IBDAC, UniDAC, or the Devart ODBC Driver for InterBase or Firebird, you may encounter the error: "Cannot load client library: <path libs>" This error typically indicates one of the following issues: The specified client ...

• Error opening table in linked server with Objects Explorer:

  contains nocolumns that can be selected or the current user does not havepermissions on that object. Reply The message "contains no columns that can be selectedor the current user does not have permissions on that object" indicatesthat the query to ...

• Using ODBC Drivers with Power BI Online

  Power BI Online supports working with ODBC drivers, but to ensure proper functionality—especially for scheduled data refresh—you need to configure the setup correctly. Make sure the Power BI Data Gateway is installed on the same computer where the ...