SinhaS

 Profile Answers by SinhaS 

• Aug 4th, 2011

 

1) First check that the Driver has been installed and the library env variable has been set correctly to point to it by the UNIX admin who installed it ($LD_LIBRARY_PATH).
2) Go to $DSHOME and update dsenv with the new driver path.
3) Stop and restart DataStage Engine - using bin/uv -admin -stop and bin/uv -admin -start commands.
4) Source in the dsenv - . ./dsenv
5) Update $DSHOME/odbc.ini to add the driver connection information for each DSN.
6) Update uvodbc.config kept in the project directory. If its not present there, then update $DSHOME/uvodbc.config
7) Check if DataStage has access to libraries that the driver libraries. Run ./ivtes under /Ascential/DataStage/branded_odbc/bin
8) Can also run the ./example under /Ascential/DataStage/branded_odbc/example and test connection to database.