Angel,
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.
Good luck,
Tony
Sybase 12.4 and Datastage 5.2
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 483
- Joined: Thu Jun 12, 2003 4:47 pm
- Location: St. Louis, Missouri USA
Angel
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.
Kim.
Kim Duke
DwNav - ETL Navigator
www.Duke-Consulting.com
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.
Kim.
Kim Duke
DwNav - ETL Navigator
www.Duke-Consulting.com
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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
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