Windows 7: ODBC Data Source Administrator

Windows 7 allows you to configure and manage multiple data sources. You can then connect to these sources for exports, imports and queries. The ODBC Data Source Administrator screen gives you control over your ODBC data sources. These contain stored information about how to connect to an indicated data provider.

In the ODBC Data Source Administrator screen you can add, delete, or set up data sources with user data source names, known as DSN’s. A user data source is only visible to you and be used only on the current computer.

The Drivers tab enables you to vies and configure the ODBC drivers on your system. These allow ODBC-enabled programs to obtain information from ODBC data sources.

The Tracing tab enables you to use the ODBC tracing feature. This allows you to create logs of the calls to ODBC drivers for use by your support staff, and to assist you in debugging your applications. The Visual Studio tracing feature enables Microsoft Visual Studio tracing for ODBC.

The Connection Pooling tab gives you access to control how applications reuse open connection handles, which saves them round-trips to the server.