Skip to content

sql-server-native-client-odbc-data-sources.md

Latest commit

 

History

History
43 lines (31 loc) · 2.2 KB

sql-server-native-client-odbc-data-sources.md

File metadata and controls

43 lines (31 loc) · 2.2 KB
title ODBC Data Sources
description SQL Server Native Client ODBC Data Sources
author markingmyname
ms.author maghan
ms.date 03/14/2017
ms.service sql
ms.subservice native-client
ms.topic reference
helpviewer_keywords
ODBC data sources, about data sources
ODBC data sources, names
data sources [SQL Server Native Client]
names [ODBC]
ODBC applications, data sources
SQL Server Native Client ODBC driver, data sources
ODBC data sources

SQL Server Native Client ODBC Data Sources

[!INCLUDESQL Server Azure SQL Database Synapse Analytics PDW]

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.

See Also

Communicating with SQL Server (ODBC)