Skip to content

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

Latest commit

 

History

History
44 lines (33 loc) · 2.13 KB

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

File metadata and controls

44 lines (33 loc) · 2.13 KB
title SQL Server Native Client ODBC Data Sources | Microsoft Docs
ms.custom
ms.date 03/06/2017
ms.prod sql-server-2014
ms.reviewer
ms.technology 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
ms.assetid a6a50fd0-d439-43fd-b76f-16ec02f478c5
author MightyPen
ms.author genemi
manager craigg

SQL Server Native Client ODBC Data Sources

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)