Skip to Content

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

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

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

I already tried to solve the issue by including the path to the in the LD_LIBRARY_PATH, setting the ODBC(INST/SYS)INI variables, copying the 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?



Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers