I'm no expert at this, so I may be way off base here.
I know that you have to have the environment variables set up correctly for DataStage to see the Sybase client drivers. The environment for DataStage can be configured in the 'dsenv' file in the ../DataStage/DSEngine directory.
You need to make sure your DataStage server has a path to the Sybase server. You need to got to the DataStage server and ping SybaseServer. If you cannot ping it then it needs to go into the hosts file. In windows the host file is usually in C:WINNTSYSTEM32DRIVERSETCHOSTS. In UNIX /etc/host.
Check that there's an entry in the uvodbc.config file for the data source. This entry must have DBMSTYPE = ODBC.
Check that you've properly configured the data source in ODBC.INI and that that file is visible as .ODBC.INI.
Test (using the utilities provided with the driver) that the driver manager is present and the driver loads correctly.
Test (using DS.CONNECT) that DataStage can connect to the DSN.
Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518
