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.
SQLSTATE=IM003, DBMS.CODE=0
Moderators: chulett, rschirm, roy
Thanks a lot for your reply, actually this issues is resolved.chulett wrote:Show us what you put in your uvodbc.config file. ...
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