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 193 while creating odbc connect in ODBC Administration

  error 193 while creating odbc Please note that our ODBC Drivers do not currently support Windows ARM. We will investigate the possibility of using our products on the Windows ARM operating system.

• Error created linked server with ODBC Drivers. Error: "Data source name not found"

  Please note that the error "Data source name not found" occurs because Microsoft SQL Server cannot access the driver. To resolve this issue, please ensure that the driver is installed on the same computer as the Microsoft SQL Server instance that you ...

• 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 ...

• ODBC Driver For InterBase. Error:"Cannot load client library: <path libs>

  This error may indicate that the driver cannot locate the specified Client Library or that the library's bitness does not match the DSN's bitness. The Devart ODBC Driver for InterBase interacts with the server through the client library using a ...

• ODBC Driver for FireBird. Error:"Cannot load client library: <path libs>

  This error may indicate that the driver cannot locate the specified Client Library or that the library's bitness does not match the DSN's bitness. The Devart ODBC Driver for FireBird interacts with the server through the client library using a ...