SQL Server Native Client ODBC Data Sources

 

System_CAPS_ICON_warning.jpg Warning

SQL Server Native Client (SNAC) is not supported beyond SQL Server 2012. Avoid using SNAC in new development work, and plan to modify applications that currently use it. The Microsoft ODBC Driver for SQL Server provides native connectivity from Windows to Microsoft SQL Server and Microsoft Azure SQL Database.

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.

Communicating with SQL Server (ODBC)

Community Additions

ADD
Show: