I target to have psqlodbc installing to AIX7.2 (7200-04-02-2028 64bit)
My questions:
1. is if AIX server may install psqlodbc at all?
2. I eventually would like to have this psqlodbc driver installed, then make a Oracle DBlink to access remote postgresDB data, anyone did that successfully with AIX?
Below are already installed to the server:
ODBC driver version 2.3.9
PostgreSQL version 11.9
I download https://codeload.github.com/postgresql-interfaces/psqlodbc/tar.gz/refs/tags/REL-17_00_0006
export LIBPATH=/opt/freeware/lib:/opt/freeware/lib64:/usr/lib64:/usr/lib:/GCI/GSDK_3.6.2/lib
PATH=/usr/bin:/etc:/usr/sbin:/usr/ucb:/usr/bin/X11:/sbin:/usr/java8_64/jre/bin:/usr/java8_64/bin:/opt/freeware/bin:/opt/freeware/sbin:/opt/IBM/xlC/16.1.0/bin:/opt/IBM/xlf/16.1.0/bin:/home/util:/usr/local/bin:.
./configure ODBCVER=0x0351 CPPFLAGS="-DSQLCOLATTRIBUTE_SQLLEN" --with-libpq=/opt/freeware/bin/pg_config --with-unixodbc=/opt/freeware/bin --disable-dependency-tracking --prefix=/usr/local --build=powerpc-ibm-aix --host=powerpc-ibm-aix CC="gcc -maix64" CXX="g++ -maix64"
When I proceed to make ang got error:
ar: 0707-126 psqlodbcw_la-win_unicode.o is not valid with the current object file mode.
Use the -X option to specify the desired object mode.
make: 1254-004 The error code from the last command is 29.