Remote Source using Generic ODBC Adapter to Postgres DB fails (Unable to load driver)

[former_member355151]

Hi all,

I am currently trying to connect a HANA Express 2.0 to a PostgreSQL DB (using the generic ODBC adapter), but I get the following error message in HANA Studio:

SAP DBTech JDBC: [403]: internal error: Cannot get remote source objects: [SAP][ODBC Driver Manager] Unable to load driver libodbcpsql.so

Using the isql command with the same driver/DNS works fine.

I already tried to solve the issue by including the path to the libodbcpsql.so in the LD_LIBRARY_PATH, setting the ODBC(INST/SYS)INI variables, copying the libodbcpsql.so into the DIR_EXECUTABLE and creating a .odbcinst.ini file with the driver in the hxeadm home... but all of that did not help.

How can I solve this problem? Did I most likely misconfigure something? Is HANA looking in the wrong place for the driver? Or is it a problem with the generic ODBC adapter?

Thanks,

Svenja