Error in connecting Oracle database

[parameswar]

Hi,
I am trying to connect database through ODBC. Following configurations are done:
1. Defined uvodbc.config in DSHOME aswell as Project directory
2. Defined .odbc.ini in DSHOME directory
3. Defined odbc entry in dsenv file as :
a). ODBCINF=/dspx00/Ascential/DataStage/branded_odbc; export ODBCINF
b). SHLIB_PATH=$SHLIB_PATH:$DSHOME/lib:$APT_ORCHHOME/lib:$APT_ORCHHOME/osh_wrappers:$ODBCINF:$ODBCINF/lib:$ORACLE_HOME:$ORACLE_HOME/lib32:$ORACLE_HOME/lib:$ORACLE_HOME/ctx/lib:$ORACLE_HOME/rdbms/lib32:$DSHOME/uvdlls:...............; export SHLIB_PATH
c). PATH=$PATH:$DSHOME/bin:$APT_ORCHHOME/bin:$APT_ORCHHOME/osh_wrappers:$ODBCINF:$ODBCINF/bin:$ORACLE_HOME/bin; export PATH

When I am trying to import column definition in manager, I am getting below error:

DSR.MetaGeta(GET.TABLES)(SQLConnect('OFDMODBC','ofsd')):BCI Error: SQLSTATE=81,CODE=0,[DataStage][SQL Client][ODBC]52380

Please any help to resolve this issue.

Regards,
Param

[ray.wurlod]

Error code 52380 has been generated by the ODBC Driver Manager. I think you now need to research via Google or Data Direct to find out what that code means.