Error created linked server with ODBC Drivers. "The specified DSN contains an architecture mismatch"

 

Please be informed that the error "The specified DSN contains an architecture mismatch" indicates that the computing of our driver and SQL Server are different.

To operate as part of Linked Server, you need to install the ODBC driver on the same machine where SQL Server is running.

If you are using SQL Server x64, when specifying the data source when creating a Linked Server, please specify a DSN with a 64-bit driver version for the data source.

• Related Articles

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

• ODBC Data Sources (64-bit) Data Source config error

  Kindly note that you are getting the GDS Function not linked error because the Client Library field specifies the path to our Devart InterBase ODBC Driver library (DevartODBCInterBase.dll), not the InterBase client library (ibclient64.dll for ...

• How to Connect to MySQL Server

  In the second article of the series uncovering how to get started with MySQL, we talk about the ways of connecting to MySQL Server. You can connect to MySQL Server using MySQL Client, dbForge Studio for MySQL, and MySQL Workbench. In this article, we ...

• what sql- syntax can be used when using ODBC Drivers?

  Please be informed, that Devart ODBC Drivers uses the SQLite engine to execute SQL queries, so in order to build queries with it you can use the syntax used in SQLite: http://www.sqlite.org/lang.html