odbc.ini - unixODBC data sources configuration
Please see following description for synopsis
odbc.ini(5) unixODBC manual pages odbc.ini(5)
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 over-
ridden by unixODBC build options, see odbcinst -j for the definitive
paths on your system.
ATTRIBUTES
See attributes(7) for descriptions of the following attributes:
+---------------+------------------+
|ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+---------------+------------------+
|Availability | library/unixodbc |
+---------------+------------------+
|Stability | Uncommitted |
+---------------+------------------+
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 con-
tain values for the keys:
o 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.
o Description
Human-readable data source description.
o Database
Database name or identifier. Meaning is driver-specific.
May specify a file path, unix socket path, identifier rela-
tive to a server name, etc.
o Servername
Server name. Meaning is driver specific, but generally
specifies a DNS name, IP network address, or driver-spe-
cific discovery identifier.
For a full list of supported parameters see the HTML-format "Adminis-
trator Manual" shipped with unixODBC, the documentation for your
driver, and any datasource templates supplied by your driver.
Source code for open source software components in Oracle Solaris can
be found at https://www.oracle.com/downloads/opensource/solaris-source-
code-downloads.html.
This software was built from source available at
https://github.com/oracle/solaris-userland. The original community
source was downloaded from
http://www.unixodbc.org//unixODBC-2.3.9.tar.gz.
Further information about this software can be found on the open source
community website at http://www.unixodbc.org/.
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.
version 2.3.6 Thu 27 Jun 2013 odbc.ini(5)