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 are trying to connect to in SQL Server Management Studio.

• Related Articles

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

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

  If you are encountering the "GDS Function not linked" error, this is because the Client Library field currently points to our Devart InterBase ODBC Driver library (DevartODBCInterBase.dll) instead of the InterBase client library (ibclient64.dll for ...

• How to Enable Logging for Source Control and Data Pump for SQL Server

  Logging is essential for capturing detailed information about failures and issues in the program. If reproducing or diagnosing a problem is difficult, logging helps in providing a deeper investigation. This guide applies to the following products: ...

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

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