ODBC for Sybase IQ

[dinagipsh]

Hi,
We have a trouble with the odbc connection to sybase iq.
Datastage 6.01, Solaris 8.
1.I edit the dsenv file to point to the Sybase iq installation directory, added the LD_LIBRARY_PATH.
2.I put the entry into .odbc.ini to point to the odbc driver like
Driver=/sybase_home/lib/dbodbc7.so
3.I edit the uvodbc.config file.
When I run the test of bin/dssh and try to connect to my datasource name, I receive the error of "Specified driver could not be loaded"
From the Datastage test that comes with the branded_odbc:
(branded_odbc/bin/ivtestlib)
I receive the error of wrong ELF class: ELFCLASS64
[?][?][?]
Thank you

[WoMaWil]

Shalom Dina,

Did you restart DataStage after changing dsenv?


Wolfgang Huerter
=====================
Cologne, Germany

[dinagipsh]

Yes, not once.

[Starg]

Hi,
Post your $ODBCINI file for the IQ section your having problems with... we use DS5.2r2 on Solaris 8 without any problems (you can also use a sybase open client stage if you want, and therefore no $ODBC settings).

Here is one of my ODBC entries for an IQ server.

[DW_IQ_A_ODBC]
Driver=/data/sybase/ASIQ_1243/asiq12/lib/libodbc.so
Descriprion=DW_IQ_A_ODBC
Database=DW_IQ_A
ServerName=DW_IQ_A
WorkstationID=E4000
LogonID=DBA
Password=SQL
OptimizePrepare=2
SelectMethod=1

Hope that helps.

Starg

[Starg]

Another action is to login as the user that runs the datastage processes (eg dsadm) and source the dsenv file, double check that all the environment settings are correct and that you can run all the standard sybase tools.

[BIuser]

Hi,

Wrong ELF class indicates that you are using the 64bit IQ driver. Install the 32 bit driver to resolve the issue.

[chulett]

Thanks for posting that for future searchers.

Still waiting for one of these to get a response like - "Thank Gawd! I've been waiting five years for someone to help me with my problem!"