TM1 9.5 + SYBASE IQ 12.7 CONNECTIVITY ISSUE : (URGENT)

[Chowdary]

Hi,

We are having issues while connecting to the SYBASE database from TI (Turbo Integrator) through ODBC.

OS :AIX 64 Bit, TM1 9.5 , Sybase IQ 12.7

Error 1 :When I click on Browse for the ODBC datasources from TM1 Turbo Integrator I'm getting the below error
"An Error occurred while retrieving datasource names from the server"
--------------------------------------------------------
Error 2 : I'm getting the below error  Whlile testing the connectivity thru odbc_test.exe

./odbc_test.exe -z <TM1 Install dir>/config [-dbname TESTDB -user DBA -passwd #$@#$@$ -query select * from EMP_TBL]


Opening config file "<TM1 install dir >/tm1s.cfg"
Error InitODBCLibraryFunctions() - attempting to load library "/home/sybase/lib/libdbodbc9.so"
Error InitODBCLibraryFunctions(), could not load library "/home/sybase/lib/libdbodbc9.so"
Error    Reason: Could not load module /home/sybase/lib/libdbodbc9.so.
        The module has an invalid magic number.
The ODBCINI environment variable is "/home/sybase/odbc.ini"

Available data source names:
Error getting data source names:
-----------------------------------------------------------
Even Cognos support couldn't help on this much...

Any Inputs pls ?
Thanks !!!

[pun_gupta]

Try the 32 bit Sybase IQ odbc driver if you aren't .. it's available on sybase.com

[mariorubbo]

I had this same exact issue.  You need a Sybase driver and an ODBC Driver Manager.  The architecture of the driver needs to match the TM1 architecture - not the Sybase architecture.  If TM1 is 64bit, then the Sybase ODBC Driver and the ODBC Driver Manager need to be 64bit.  If TM1 is 32bit, then the Sybase ODBC Driver and the ODBC Driver Manager need to be 32bit.

For Driver Manager, we used a unixODBC package provided by a company called EasySoft.  unixODBC is open-source.  EasySoft is a company that provides support for unixODBC.

The ""/home/sybase/lib/libdbodbc9.so" line in your TM1S.CFG file points to the ODBC Driver provided by Sybase.  This is not a full implementation of an ODBC Driver Manager - it is a fake provided by Sybase that is sufficient for some applications.  TM1 requires a full implementation - aka unixODBC or iODBC.

After installing the ODBC Driver Manager, the libraries may be provided as ".a" files which are UNIX archives.  This is also incompatible with TM1.  TM1 can only point to an ".so" file.  There is a UNIX command you can execute that will extract a ".so" file from the ".a" archive.

[jayanthhyd]

Guys while installing tm1 i am getting this error ""Error 1919 Error configuring odbc data source plain_load_data odbc error 6: Component not found in the registry. Verify that the file plan_load_data exists and you can access it"" can any one help me jayanth1255@gmail.com thank you..