Configure a Data Source (Linux)¶

A data source configuration is a collection of information that identifies the database you want to access using the ODBC driver. You must configure a data source before connecting to a database through ODBC.

To configure a new data source on Linux

Run the ODBC Administrator utility, iiodbcadmin.

iiodbcadmin Utility¶

The ODBC Administrator (iiodbcadmin) utility lets you perform the following tasks:

• Create, edit, and remove data sources

• Perform configuration tasks for each installed driver, including:

  • –Turn on ODBC tracing

  • –Define the path of the driver

  • –View details about the configuration

  • –Set configuration options, such as connection pooling timeout

• Test a data source connection

For details, see the ODBC Administrator online help.