When using the ODBC driver on Linux platforms, register the ODBC driver using the following procedure:
Install the ODBC driver manager (unixODBC).
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.
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).
|
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