SQLSTATE=IM003, DBMS.CODE=0

ajaykumar · Post by **ajaykumar** » 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.

chulett · Post by **chulett** » Sun Oct 10, 2010 4:51 pm

Show us what you put in your uvodbc.config file.

ajaykumar · Post by **ajaykumar** » Tue Oct 26, 2010 9:05 am

chulett wrote:Show us what you put in your uvodbc.config file. ...

Thanks a lot for your reply, actually this issues is resolved.

Driver=/opt/dsadm/Ascential/DataStage/branded_odbc/lib/VMase19.so

we change the path to

/opt/IBM/InformationServer/Server/branded_odbc/lib/VMase23.so.

we migrated from 7.5 to 8.1 in 8.1 the paths have changed.

Thanks again