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 SQL-92 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
| Topic | Description |
|---|---|
The uses of the ODBC Data Source Administrator application. |
|
Describes the three ways of adding or deleting a data source. |
See Also
Concepts
Other Resources
ODBC API Implementation Details