| title | SQL Server Native Client ODBC Data Sources | Microsoft Docs | |||||||
|---|---|---|---|---|---|---|---|---|
| ms.custom | ||||||||
| ms.date | 03/14/2017 | |||||||
| ms.prod | sql | |||||||
| ms.prod_service | database-engine, sql-database, sql-data-warehouse, pdw | |||||||
| ms.reviewer | ||||||||
| ms.technology | native-client | |||||||
| ms.topic | reference | |||||||
| helpviewer_keywords |
|
|||||||
| ms.assetid | a6a50fd0-d439-43fd-b76f-16ec02f478c5 | |||||||
| author | markingmyname | |||||||
| ms.author | maghan | |||||||
| monikerRange | >=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current |
[!INCLUDEappliesto-ss-asdb-asdw-pdw-md]
A [!INCLUDEssNoVersion] data source name (DSN) identifies an ODBC data source containing all of the information that an ODBC application needs to connect to a [!INCLUDEssNoVersion] database on a specific server. There are two ways you can define an ODBC data source name:
-
On a client computer, open Administrative Tools in Control Panel, and double-click Data Sources (ODBC). This will open the ODBC Data Source Administrator, which you can use to create a DSN.
-
In an ODBC application, call SQLConfigDataSource.
A [!INCLUDEssNoVersion] data source contains:
-
The name of the data source.
-
Any information needed to connect to a specific instance of [!INCLUDEssNoVersion].
-
The default database to use on a specific instance of [!INCLUDEssNoVersion] (optional).
-
Settings such as which ANSI options to use, whether to log performance statistics, and so on (optional).
An ODBC application is not required to connect through a data source. However, the application must provide the same connectivity information to an ODBC connect function that the driver would otherwise find in a DSN.