Export (0) Print
Expand All
2 out of 5 rated this helpful - Rate this topic

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.

Using the ODBC Data Source Administrator

The uses of the ODBC Data Source Administrator application.

Adding or Deleting an ODBC Data Source

Describes the three ways of adding or deleting a data source.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.