ODBC - odbcinst.ini

About

odbcinst.ini has all driver information configuration. See ODBC - unixODBC

Configuration file containing all the database drivers specifications. odbcinst.ini

Articles Related

File

Location

Run:

odbc_config --odbcinstini
# or it can also be seen in:
odbcinst -j

Normally: /etc/odbcinst.ini

Syntax

In the odbcinst ini file, each ODBC driver has its own section and can be referred to by the name of its section.

Recognized configuration, keys 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: odbcinst entry, if you edit the configuration file by hand, you have to supply it yourself. ???

The shared library driver extension is operating system dependent:

• .so for Linux, Solaris, or AIX,
• .sl for HP-UX.

Example: How to add a driver system wide

• First create a template template.ini:

[PostgreSQL]
Description = PostgreSQL driver for GNU/Linux
Driver      = /usr/lib/psqlodbcw.so
Setup       = /usr/lib/libodbcpsqlS.so

• Apply the template

$ odbcinst -i -d -f template.ini

• Then reference it in the odbc.ini as follows:

Driver = PostgreSQL