odbc.ini - Man Page

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.

Referenced By

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

Thu 27 Jun 2013 version 2.3.6 unixODBC manual pages