Configuring Database Connections

There are two methods for connecting to the RDBMS; connection strings and using ODBC drivers. See Database Connections for more information.

There are a number of different driver managers that you can use to configure ODBC data sources. These instructions are carried out using unixODBC. If you are using a different driver manager, consult the vendor instructions for creating data sources:

Run the command odbcinst -j, and note down the location of the drivers configuration file (odbcinst.ini) and the user data sources configuration file (.odbc.ini).
Open the odbcinst.ini configuration file and ensure that you have something similar to the following:
```
[PostgreSQL]
Description=ODBC for PostgreSQL
Driver64=/usr/pgsql-10/lib/psqlodbcw.so
Setup64=/usr/lib64/libodbcpsqlS.so
FileUsage=1
Threading=2
```
Note: Ensure that the threading setting is specified, this avoids potential problems when performing database operations on multiple threads.
This might differ depending on the version of PostgreSQL you are running.

See the Configuration Requirements chapter for more configuration information.