DSXchange

I am trying to connect to a netezza source DB by using netezza connector. I have installed the netezza drivers. I am able to connect through terminal from IIS server, but not through DS. Please help to resolve the issue.

My DS server is Redhat and DS Version : 11.5
Netezza client Drivers : 7.2.1.2 (32 & 64)

I am getting the following error while using the Netezza connector stage:

Connection to database <db name> with user <user name>
using DSN NZESAPDA failed. Reason: [SQLCODE=IM003][Native=0]
[Datadirect][ODBC lib] Specified driver could not be loaded.

Here is my Driver settings in .odbc.ini file :

[NZESAPDA]
Driver=/usr/local/nz/lib64/libnzodbc.so
Description=ESA Netezza PDA
Servername=pda1-wall.boulder.ibm.com
Port=5480
Database=BACC_PRD_EAPDA_EAPDA
Username=gbseubob
Password=
ReadOnly=false
ShowSystemTables=false
LegacySQLTables=false
LoginTimeout=0
QueryTimeout=0
;Specifies date format as follows -
; 1: YMD
; 2: MDY
; 3: DMY
DateFormat=1
NumericAsChar=false
SQLBitOneZero=false
StripCRLF=false
securityLevel=preferredUnSecured
caCertFile=


Here is my dsenv file :

DSHOME=/opt/IBM/InformationServer/Server/DSEngine; export DSHOME
PATH=$PATH:$INSTHOME/sqllib/bin:$INSTHOME/sqllib/adm:$INSTHOME/sqllib/misc:$INSTHOME/sqllib/db2tss/bin:$DSHOME/bin:$DB2PATH/bin:/usr/local/nz/bin
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$INSTHOME/sqllib/lib:$DB2PATH/lib64:/usr/local/nz/lib:/usr/local/nz/lib64
export ODBCINI=$DSHOME/.odbc.ini
export NZ_ODBC_INI_PATH=$DSHOME

So... you are running a 64bit version of DataStage?

Try restarting the DataStage Engine and the ASB Agent

Hi Guys.. the issue got resolved.
I had installed the 32 version drivers previously. So i replaced with 64bit and it worked.