Setup data sources (ODBC)

1. Click on the start button

2. Then click on control panel on the right side of the start menu

3. Click on category next to view by:

4. Change to small icons

5. Click on administrative tools

6. From there click on Data Sources (ODBC)

7. That will open ODBC Data Source Administrator dialog box. Use this tab (User DNS) to add, delete, or set up data sources with user data source names (DSNs). These data sources are local to a computer and accessible only by the current user.

8. Click on the System DNS tab and Use this tab to add, delete, or set up data sources with system data source names (DSNs). These data sources are local to a computer but not user-dedicated. Any user with the correct permissions can access a system DSN.

9. Click on file DNS tab and use this tab to add, delete, or set up file-based data sources that can be shared among all users who have the same drivers installed. These data sources don't need to be user-dedicated or local to a computer.

10. Click on the Drivers tab and This tab displays information about the ODBC drivers installed on your computer. No action can be performed from this tab. You must use the specific driver setup program to add or remove ODBC drivers.

11. Click on the Tracing tab and this tab specifies how the ODBC Driver Manager traces calls to ODBC functions. Tracing is performed by a trace DLL that captures calls between the Driver Manager and either the application or the driver, and then records them in a log file. The Driver Manager can:

· Trace calls continuously or for one connection only

· Perform tracing dynamically

· Allow tracing to be performed by a custom trace .dll file

12. Click on the Connection Pooling Tab. Connection pooling enables an ODBC application to reuse a connection from a pool of connections. Use this tab to alter the connection retry wait time and time-out period for a selected driver when using connection pooling. You can also enable and disable performance monitoring, which records a number of connection statistics.

13. Click on the About tab and this tab displays information about the ODBC core components, including the Driver Manager, the cursor library, the installer .dll file, and other files that constitute the core components.

http://windows.microsoft.com/en-US/windows-vista/Using-the-ODBC-Data-Source-Administrator

James Ugolik