odbcinst.ini - An unixODBC drivers configuration
Please see following description for synopsis
odbcinst.ini(5) unixODBC manual pages odbcinst.ini(5)
NAME
/etc/odbcinst.ini - An unixODBC drivers configuration
DESCRIPTION
/etc/odbcinst.ini is a text configuration file for unixODBC drivers. It
can be edited by hand, but the recommended way to update this file is
to use the odbcinst(1) utility.
FILE FORMAT
The general .ini file format is:
[SectionName1]
key1 = value1
key2 = value2
...
[SectionName2]
key1 = value1
key2 = value2
...
Each ODBC driver has its own section and can be referred to by the name
of its section. Configuration keys recognised in driver sections by
unixODBC itself are:
Description
A text string briefly describing the driver.
Driver A filesystem path to the actual driver library.
Setup A filesystem path to the driver setup library.
FileUsage
The section named [ODBC] configures global options. Keys recog-
nised in the [ODBC] section include:
Trace
Enable ODBC driver trace output, which is written to the path
specified by TraceFile.
Note that some drivers have their own separate trace control
options. Unlike the Trace option these are usually specified at
the DSN level.
Values recognised as enabled are any case variation of "1", "y",
"yes" or "on".
TraceFile
Path or path-pattern to write the ODBC trace file to. Has no
effect unless Trace is enabled. Default /tmp/sql.log.
WARNING: setting TraceFile to a path writeable by multiple users
may not work correctly as only the first user will be able to
create and open the file.
TEMPLATE FILES
The recommended way to manage the drivers is using the odbcinst(1)
utility. You can install the drivers by supplying it with template
file, which has the same format as this file.
EXAMPLES
An example of the actual PostgreSQL driver:
[PostgreSQL]
Description = PostgreSQL driver for GNU/Linux
Driver = /usr/lib/psqlodbcw.so
Setup = /usr/lib/libodbcpsqlS.so
FileUsage = 1
Note that driver paths may vary, and some drivers require Driver64 and
Setup64 entries too.
By specifying the driver like that, you can then reference it in the
odbc.ini(5) as follows:
Driver = PostgreSQL
The recommended way to add that driver is by creating a template file
containing:
[PostgreSQL]
Description = PostgreSQL driver for GNU/Linux
Driver = /usr/lib/psqlodbcw.so
Setup = /usr/lib/libodbcpsqlS.so
and call the odbcinst(1):
# odbcinst -i -d -f template.ini
ATTRIBUTES
See attributes(7) for descriptions of the following attributes:
+---------------+------------------+
|ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+---------------+------------------+
|Availability | library/unixodbc |
+---------------+------------------+
|Stability | Uncommitted |
+---------------+------------------+
SEE ALSO
unixODBC(7), odbcinst(1), odbc.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.
NOTES
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/.
version 2.3.6 Thu 27 Jun 2013 odbcinst.ini(5)