Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

SQL Server Native Client ODBC Data Sources

 

Applies To: SQL Server 2016 Preview

A SQL Server data source name (DSN) identifies an ODBC data source containing all of the information that an ODBC application needs to connect to a SQL Server 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 SQL Server data source contains:

  • The name of the data source.

  • Any information needed to connect to a specific instance of SQL Server.

  • The default database to use on a specific instance of SQL Server (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.

Community Additions

ADD
Show:
© 2015 Microsoft