Connect Intersystems Cache db on Linux
I am trying to configure Intersystems Cache ODBC driver on Red Hat Linux. When we installed it using ODBC-2015.2.1.705.0-lnxrhx86.tar.gz from Intersystems downloads, it has generated number of .so odbc driver files under installdir/bin folder. I am trying to use libcacheodbc.so on file DSN as driver, but it says "communication link failure Driver's SetSQLConnectAttr failed". We are using following entries on odbc.ini:
Driver=/u01/xxxx/install/lib32/libcacheodbc.so
Description=Cache ODBC Driver
Server=server ip address
Port=1972
Namespace=CCMS_STAT
Authentication Method=0
Query Timeout=1
Can you advise if it should be different driver file that I should use/if dsn entries are okay?
Thanks and Regards