Configuration Through the Administrator

The Linux ODBC Administrator is located in the /tools directory of the product installation directory. For example,

The following drivers can be configured with the Linux ODBC Administrator:

Note that all of the drivers included in your odbc.ini file are shown in the User Data Sources list box, even though some of them cannot be used with the Linux ODBC Administrator.

1. To start the Linux ODBC Administrator, change to the install_dir/tools directory, where install_dir is the path to the product installation directory. At a command prompt, enter:

2. Click either the User DSN or File DSN tab to display a list of data sources.

◦ User DSN: If you are configuring an existing user data source, select the appropriate data source name and click Configure to display the driver Setup dialog box.

If you are configuring a new user data source, click Add to display a list of installed drivers. Select the appropriate driver and click Finish to display the driver Setup dialog box.

◦ File DSN: If you are configuring an existing file data source, select the appropriate data source file and click Configure to display the driver Setup dialog box.

To configure a new file data source, click Add to display a list of installed drivers. Select the appropriate driver and click Advanced to specify attributes; otherwise, click Next to proceed. Specify a name for the data source and click Next. Verify the data source information; then, click Finish to display the driver Setup dialog box.

Note: If you want to set a default directory for File DSNs, select the directory from the Directories list; then, click Set Directory. The next time that you open the Administrator, it displays data source files from this directory.

The General tab of the driver Setup dialog box appears by default.

See the individual driver chapters for specific information about the driver Setup dialog. See Quick Start Connect for an explanation of different types of data sources.