SQLSTATE=IM003, DBMS.CODE=0
Posted: Sun Oct 10, 2010 2:12 pm
Hi,
Today i created a new odbc.ini configuration and added that value in the project specific uvodbc.config file also. But when i executed the job I am getting the following Error.
REFTMML..tMML: |REFTMML..TMAJMIN: DSD.BCIConnect connecting to GOALD_PROD, call to function SQLConnect failed.
SQLSTATE=IM003, DBMS.CODE=0
[DataStage][SQL Client][ODBC][DataDirect][ODBC lib] Specified driver could not be loaded|.
vi odbc.ini
[GOALD_PROD]
Driver=/opt/dsadm/Ascential/DataStage/branded_odbc/lib/VMase19.so
Description=DataDirect Sybase Wire Protocol
ArraySize=50
CursorCacheSize=1
Database=
DefaultLongDataBuffLen=1024
EnableDescribeParam=0
EnableQuotedIdentifiers=0
LogonID=
NetworkAddress=sybcip1.aig.net,5000
OptimizePrepare=1
PacketSize=0
Password=
RaiseErrorPositionBehavior=0
SelectMethod=0
Any Suggestions would be really helpful.
Today i created a new odbc.ini configuration and added that value in the project specific uvodbc.config file also. But when i executed the job I am getting the following Error.
REFTMML..tMML: |REFTMML..TMAJMIN: DSD.BCIConnect connecting to GOALD_PROD, call to function SQLConnect failed.
SQLSTATE=IM003, DBMS.CODE=0
[DataStage][SQL Client][ODBC][DataDirect][ODBC lib] Specified driver could not be loaded|.
vi odbc.ini
[GOALD_PROD]
Driver=/opt/dsadm/Ascential/DataStage/branded_odbc/lib/VMase19.so
Description=DataDirect Sybase Wire Protocol
ArraySize=50
CursorCacheSize=1
Database=
DefaultLongDataBuffLen=1024
EnableDescribeParam=0
EnableQuotedIdentifiers=0
LogonID=
NetworkAddress=sybcip1.aig.net,5000
OptimizePrepare=1
PacketSize=0
Password=
RaiseErrorPositionBehavior=0
SelectMethod=0
Any Suggestions would be really helpful.