ODBC - odbcinst.ini

Card Puncher Data Processing


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

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




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

Normally: /etc/odbcinst.ini


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:
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

Discover More
Card Puncher Data Processing

The odbc.ini file is a unixodbc configuration file that define data sources name (DSN). Every DSN to which your application connects must have an entry in this file. odbcinst (odbc installer)...
Card Puncher Data Processing
ODBC - odbcinst (odbc installer)

odbcinst (odbc installer) is the ODBC Installer and Uninstaller command line tool which can create/remove entries in odbc.ini and odbcinst.ini It can still be done manually. It updates system files,...
Card Puncher Data Processing
Oracle Database - ODBC Driver Insallation on Linux

where is the data manager home () and ~/.odbc.ini === Drivers === Example odbcinst.ini === DSN === odbc.ini Minimal parameters Complete: ==== Test it ==== with ===== Support...
Card Puncher Data Processing
UnixODBC - odbc_config (UnixODBC environment)

This articles talks the utility odbc_config. It permits to retrieve scalar configuration information. For the configuration of DSN, see
Card Puncher Data Processing
unixODBC - Diagnostic Tracing

To trace your application behavior, first add the following line to the odbcinst.ini file: The general form is: Then you start the trace with strace. For example: Example with isql Output: ENOENT:...

Share this page:
Follow us:
Task Runner