The odbc.ini file

The odbc.ini file is a sample data-source configuration information file.

For the location of the odbc.ini file, see the release notes. To create this file, copy odbc.ini to your home directory as $HOME/.odbc.ini (note the added dot at the beginning of the file name). Every DSN to which your application connects must have an entry in this file. The following table describes the sections in $HOME/.odbc.ini.
Section Description Status
ODBC Data Sources This section lists the DSNs and associates them with the name of the driver. You need to provide this section only if you use an ODBC driver manager from a third-party vendor. Required
Data Source Specification Each DSN listed in the ODBC Data Sources section has a Data-Source Specification section that describes the DSN. Required
ODBC This section lists ODBC tracing options. Optional
Follow these rules to include comments in the odbc.ini file on UNIX™ systems:
  • Begin a comment with a semicolon (;) or number sign (#) in the first position of the first line.
  • If a comment includes multiple lines, you can begin following comment lines with a space or tab character (\t).
  • You can include blank lines in comments.