DSXchange

Posted: **Sun Mar 25, 2007 1:28 pm**

Hi

I am trying to configure a native connection with the database Informix, but when trying to import table definitions returns Unable to initialize plug-in.

dsenv file:

Code: Select all

INFORMIXDIR=/home/informix7; export INFORMIXDIR
INFORMIXSERVER=u01r_rede; export INFORMIXSERVER
LIBPATH=$LIBPATH:$INFORMIXDIR/lib:$INFORMIXDIR/lib/esql:$INFORMIXDIR/lib/cli; export LIBPATH

I configured a connection ODBC in the file odbc of the type DataDirect and I got to import a table definition, but I don't get through the plug-in. The Informix CLI SDK 2.9 was installed.

.odbc.ini file:

Code: Select all

[ifmxu01r]
QEWSD=37499
Driver=/datastage/Ascential/DataStage/branded_odbc/lib/VMinf5120.so
Description=DataDirect Informix
Database=porto
ServerName=u01r_rede
HostName=u125
Service=sqldu01r 
Protocol=onsoctcp
EnableInsertCursors=0
GetDBListFromInformix=0
CursorBehavior=0
CancelDetectInterval=0
TrimBlankFromIndexName=1
ApplicationUsingThreads=1

Can anybody help me with this problem?

Thanks in advance

Regards,

Luciana

Code: Select all

Posted: **Thu Aug 02, 2007 5:37 pm**

I will post the solution of my problem here, this can help somebody with the same problem.

WebSphere DataStage is a 32-bit application. If you are running in a 64-bit environment, you must ensure any database clients you use are also 32 bit.

The problem was solved installing Informix Client 32 bit.

Posted: **Thu Aug 02, 2007 7:02 pm**

... and making sure the 32-bit libraries appear in LIBPATH for DataStage processes instead of or, at the very least, ahead of the 64-bit libraries.

DSXchange

Informix - Unable to initialize plug-in

Informix - Unable to initialize plug-in