We have a BO XI 3.1 deployment on Linux. We need to access data from Sybase IQ 15 urgently. However the Sybase IQ 15 driver only works with Windows client (Designer, Desktop Intelligence (2-tier)) but not on the (Linux) server.
I understand Sybase IQ 15 is not officially supported. From my investigation, I notice the connectionServer directory only includes libdbd_dbodbc9.so and libdbd_dbodbc10.so which requires libdbodbc9_r.so or libdbodbc10_r.so (and other libraries of the same version) from the database ODBC driver. The libraries in the Sybase IQ 15 client, however, are all version 11 (i.e. xxxxx11.so). When running a report with Sybase IQ 15 connection, one will always get the following error because the libraries of that specific version doesn't exist in the IQ 15 client:
DBDriver failed to load : /.../dataAccess/RDBMS/connectionServer/libdbd_dbodbc10.so: open failed: No such file or directory
I just wonder if we can tweak BO to make IQ 15 driver work. Here is what I'm thinking:
1. Put libdbd_dbodbc11.so to the connectionServer directory
2. Configure BO to add a new database (Sybase ASIQ 15) in the ODBC layer and make it use libdbd_dbodbc11.so for the connection.
Can any expert in this forum advise:
1. Is the above workaround a feasible approach?
Any help is highly appreciated.