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