ODBC Data Source Administrator Dialog

Access the ODBC Data Source Administrator dialog by clicking ODBC Administator from within the Database Setup Wizard after you have selected ODBC Data Source as the database type that you want to use. For more information about any portion of the ODBC Data Source Administrator dialog, please consult your Windows documentation.

Using this dialog, you can perform the following tasks:

The following tabs are available: 

ClosedUser DSN Tab

The User DSN tab enables you to add, delete, and configure user data sources. Existing user data sources are listed in the User Data Sources list box. User data sources are visible only to the user who creates them and only on the machine on which they are created.

ClosedSystem DSN Tab

The System DSN tab enables you to add, delete, and configure system data sources. Existing system data sources are listed in the System Data Sources list box. These data sources are local to a computer, rather than dedicated to a user. The system, or any user who has privileges, can use a data source that is configured to have a system DSN.

ClosedFile DSN Tab

The File DSN tab enables you to add, delete, and configure file data sources. Existing file data sources are listed in the list box on the left side of the dialog. These data sources can be shared among all users who have the same ODBC drivers installed; they are not dedicated to a specific user or computer.

ClosedDrivers Tab

The Drivers tab displays information about the installed ODBC drivers. The ODBC Drivers list shows you which drivers are already installed on your computer. No actions are performed from this tab.

ClosedTracing Tab

The Tracing tab enables you to specify how the ODBC Driver Manager traces calls to ODBC functions. The Driver Manager can trace calls, perform tracing dynamically, or allow tracing to be performed by a custom trace DLL.

When to trace

Machine-wide tracing should be enabled only when it is needed; otherwise, it should be turned off.

Log File Path

The Log File Path section displays the path and file name where the tracing information will be stored. You can use the default path and file name (\sql.log) or specify a new file either by entering a new path and file name or by clicking Browse and then selecting a directory and file.

Custom Trace DLL

The Custom Trace DLL section displays the path and file name for DLL tracing. You can use the default path and file name (Odbctrac.dll) or specify a new file either by entering the path and file name of the custom *.dll or by clicking Select DLL to browse to and then select a directory and file.

ClosedConnection Pooling Tab

The Connection Pooling tab enables you to alter the connection retry wait time and connection timeout period for a selected driver when using connection pooling. It also enables you to turn Performance Monitoring off and on, which records a number of connection statistics.

Connection Pooling Timeout

The Connection Pooling Timeout section sets the connection pooling timeout interval, in seconds, for the selected driver. To set connection pooling attributes, double-click the driver name. In the Set Connection Pooling Attributes dialog, you can set a time period during which unused connections remain in the pool and can also activate connection pooling for the selected driver.

PerfMon

The PerfMon section determines whether performance-monitoring counters for connection pooling are turned on or off. For more information about performance monitoring, see Microsoft's ODBC Programmer's Reference.

Retry Wait Time

The Retry Wait Time section specifies, in seconds and in fewer than six numerals, how long the ODBC Driver Manager waits before making connection retries to a database server.

ClosedAbout Tab

The About tab displays information about the ODBC core components, including the Driver Manager, the cursor library, the installer .dll, and other files that constitute the core components. No actions are performed from this tab; clicking Cancel does not undo changes that are made on other tabs.