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:

1. The ODBC driver is correctly installed on the same machine where the SQL Server instance is running.
   
2. The DSN (Data Source Name) used in the linked server configuration is properly created in the ODBC Data Source Administrator (32-bit or 64-bit, depending on your SQL Server version).

Without local access to the driver and DSN, SQL Server Management Studio will not be able to establish a connection to the external data source.

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

• Guide: Configuring ODBC Driver in Azure Data Factory

  This guide walks you through the steps of setting up and using an ODBC driver in Azure Data Factory (ADF) for seamless data integration. By following this guide, you will be able to configure an ODBC driver, create a Linked Service, and define an ...

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

• Setting Up MongoDB Atlas and Connecting via Devart ODBC Driver

  This article will guide you through the process of setting up MongoDB Atlas, creating a cluster, configuring access, obtaining the connection string, and connecting to MongoDB Atlas using the Devart ODBC Driver for MongoDB. 1. Creating a Cluster in ...

• Setting up a Connection to ODBC in Delphi Using Devart ODBC Driver

  This guide will walk you through the steps of setting up a connection to an ODBC driver in Delphi. We'll use ODBC Driver for Salesforce as an example. Prerequisites: Devart ODBC Driver for Salesforce installed on your machine. A Salesforce account ...