Top
Enterprise Postgres 17 SP1 Application Development Guide

Linux3.2.1 Registering ODBC Drivers

When using the ODBC driver on Linux platforms, register the ODBC driver using the following procedure:

  1. Install the ODBC driver manager (unixODBC).

  2. Register the ODBC drivers.

    Edit the ODBC driver manager (unixODBC) odbcinst.ini file.

    Information

    [location of the odbcinst.ini file]

    unixOdbcInstallDir/etc/odbcinst.ini

    Set the following content:

    Definition name

    Description

    Setting value

    [Driver name]

    ODBC driver name

    Set the name of the ODBC driver.

    Select the two strings below that correspond to the application type. Concatenate the strings with no spaces, enclose in "[ ]", and then specify this as the driver name.

    Note

    The placeholders shown below are enclosed in angle brackets '<>' to avoid confusion with literal text. Do not include the angle brackets in the string.

    • Application architecture

      "FujitsuEnterprisePostgres<fujitsuEnterprisePostgresClientVers>x64"

    • Encoding system used by the application

      • In Unicode (only UTF-8 can be used)

        "unicode"

      • Other than Unicode

        "ansi"

    Example: The encoding system used by the application is Unicode:

    "[FujitsuEnterprisePostgres<fujitsuEnterprisePostgresClientVers>x64unicode]"

    Description

    Description of the ODBC driver

    Specify a supplementary description for the current data source. Any description may be set.

    Driver64

    Path of the ODBC driver (64-bit)

    Set the path of the ODBC driver (64-bit).

    • If the encoding system is Unicode:

      fujitsuEnterprisePostgresClientInstallDir/odbc/lib/psqlodbcw.so
    • If the encoding system is other than Unicode:

      fujitsuEnterprisePostgresClientInstallDir/odbc/lib/psqlodbca.so

    FileUsage

    Use of the data source file

    Specify 1.

    Threading

    Level of atomicity secured for connection pooling

    Specify 2.

    Example

    Note that "<x>" indicates the product version.

    [Fujitsu Enterprise Postgres<x>x64unicode]
    Description = Fujitsu Enterprise Postgres <x> x64 unicode driver
    Driver64    = /opt/fsepv<x>client64/odbc/lib/psqlodbcw.so
    FileUsage   = 1
    Threading   = 2