NAME

       /etc/odbc.ini, $HOME/.odbc.ini - unixODBC data sources configuration

DESCRIPTION

       /etc/odbc.ini  is  text  configuration  file  for  the  system  wide  ODBC  data  sources (i. e. database
       connections).  $HOME/.odbc.ini contains the configuration for user-specific data sources. Both paths  may
       be overridden by unixODBC build options, see odbcinst -j for the definitive paths on your system.

NOTES

   Templates
       Where  possible,  install  ODBC  DSNs  using the odbcinst utility from a template .ini file. Many drivers
       supply templates.

   FILE FORMAT
       odbc.ini follows the pesudo-standard ini file syntax convention of one or more [section  headings],  each
       followed by zero or more key = value attributes.

       [ODBC Data Sources] section

           The  required  section [ODBC Data Sources] lists each data source name (DSN) as a key. The associated
           values serve as comments. Each entry must be matched by an ini file  [section]  describing  the  data
           source.

       [dsn] sections

           Each  data  source  is  identified by a [section header], which is the DSN name used by applications.
           Each DSN definition section may contain values for the keys:

           • Driver (REQUIRED)
                   Name of the ODBC driver to use for this DSN. The name must exactly match the  [section  name]
                   of the driver definition in odbcinst.ini as listed by odbcinst -q -d.

           • Description

                   Human-readable data source description.

           • Database

                   Database name or identifier. Meaning is driver-specific. May specify a file path, unix socket
                   path, identifier relative to a server name, etc.

           • Servername

                   Server name. Meaning is driver specific, but generally  specifies  a  DNS  name,  IP  network
                   address, or driver-specific discovery identifier.

       For a full list of supported parameters see the HTML-format "Administrator Manual" shipped with unixODBC,
       the documentation for your driver, and any datasource templates supplied by your driver.

EXAMPLES

       An example odbc.init is shown in the "Administrator Manual" shipped with unixODBC.

SEE ALSO

       unixODBC(7), odbcinst(1), isql(1), iusql(1), odbcinst.ini(5)

       "The unixODBC Administrator Manual (HTML)"

AUTHORS

       The authors of unixODBC are Peter Harvey <pharvey@codebydesign.com> and Nick  Gorham  <nick@lurcher.org>.
       For the full list of contributors see the AUTHORS file.

COPYRIGHT

       unixODBC  is licensed under the GNU Lesser General Public License. For details about the license, see the
       COPYING file.