Configuring ODBC Data Sources

An Open Database Connectivity (ODBC) application uses an ODBC data source to connect to an instance of Microsoft SQL Server. An ODBC data source is a stored definition that records:

  • The ODBC driver to use for connections specifying the data source.

  • The information used by the ODBC driver to connect to a source of data.

  • Driver-specific options to be used for the connection. For example, a SQL Server ODBC data source can record the ISO options to use, or whether the drivers should record performance statistics.

Each ODBC data source on a client has a unique data source name (DSN). An ODBC data source for the SQL Server ODBC driver includes all the information used to connect to an instance of SQL Server, plus any essential options.

In This Section