odbcinst.ini Driver Configuration (unixODBC)

  • Document ID:7023661
  • Creation Date:22-Jan-2019
  • Modified Date:22-Jan-2019
    • Micro Focus Products:
      Privileged Account Manager (Privileged User Manager)

Environment

Privileged Account Manager

Situation

How to configure unixODBC's odbcinst.ini configuration file for integration with Privileged Account Manager (PAM).

Resolution

The Driver line in the odbcinst file is used to find the path for the driver library for UnixODBC. This would then be loaded and the connection established. Each driver would be configured as a [section] entry in this file.

The Name of the Driver as defined by the [section] entry header is used as the Driver attribute defined in the odbc.ini configuration file.
Note: For more information on the odbc.ini configuration file, please refer to TID 7021177 - odbc.ini Connection String Keywords (unixODBC).

As an example, the odbcinst.ini file may look something like this:

[ODBC Driver 11 for SQL Server]
Description  = Microsoft ODBC Driver 11 for SQL Server
Driver          = /usr/lib64/libmsodbcsql-11.0.so.2260.0

[PostgreSQL]
Description  = Test to Postgres
Driver       = /usr/local/lib/libodbcpsql.so

Additional Information

For more information on the odbcinst.ini configuration file, please refer to UnixODBC: