The odbc.ini or odbcinst.ini files are not configured correctly in the /vardir/odbc directory or the environment variables ODBCINI or ODBCSYSINI are set incorrectly.
Solution 1 (odbc.ini and odbcinst.ini configuration):
Configure the odbc.ini and odbcinst.ini files as per the instructions in the SharePlex Installation Guide.
Example: odbc.ini
[testdb]
Driver = PostgreSQL
Database = testdb
Servername = 10.250.40.27
Port = 5432
Uid=splex
Pwd=splex
TrustServerCertificate=Yes
Connection Timeout=30
Trusted_Connection=Yes
Example: odbcinst.ini
# Driver from the postgresql-odbc package
# Setup from the unixODBC package
[PostgreSQL]
Description = ODBC for PostgreSQL
Driver = /usr/lib/psqlodbcw.so
Setup = /usr/lib/libodbcpsqlS.so
Driver64 = /usr/lib64/psqlodbcw.so
Setup64 = /usr/lib64/libodbcpsqlS.so
FileUsage = 1
Solution 2 (ODBCINI or ODBCSYSINI variables):
To verify if the variables are set on a Linux environment, run the following:
env | grep ODBC
If the variables are set, correct the ODBCINI or ODBCSYSINI variables to point to the correct odbc.ini and odbcinst.ini files. You can also unset the variables before running pg_setup to use the files in $SP_SYS_VARDIR/odbc/:
unset ODBCINI
unset ODBCSYSINI
