informix odbc driver

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
przytulaguy
Participant
Posts: 14
Joined: Fri Jun 19, 2009 5:39 am
Location: KERMT

informix odbc driver

Post by przytulaguy »

we have migrated from ds 7.5 to 8.1
the old odbc.ini file was pointing to
Driver=/opt/infosphere-install/InformationServer/Server/branded_odbc/lib/VMinf23.so
Description=DataDirect Informix driver
it seems this driver is not anymore available on 64b machines
we now have a request from ibm to configure a new connection
Looking further into this issue I think you may be hitting a known
problem on 64bit platforms : the InformixCLI plugin stage cannot be used
with the DataDirect Informix Wire Protocol, and needs the Non-Wire
Protocol driver which does not exist on 64bit platforms. From our
previous experiences around this issue, you need to use the Informix
ODBC driver that is shipped with the Informix client software.
Could you please configure a DSN with the Informix driver and test the
job once again ?
==
the question is : where can we find a list of driver names we have to use for a specific engine/platform an know if it is wired/non-wired
thanks for all update/help
best regards, Guy przytula
Best Regards, Guy Przytula
Post Reply