Hi,
We have a DataStage 7.5.2 placed on LINUX RH platform. We have serious problems when connecting via ODBC connection to the SQL sever 2000. The problem is that whenever we try to import table metadata into DataStage the connection between client and server brokes with error saying: Error calling subroutine: DSR_IMPORT (Action=2); check DataStage is set up correctly in project PROJECTNAME. (The connection is broken (81002)).
All nedded configurations in dsenv, uvodbc.config and .odbc.ini files are configured by the book. Let me also tell 2 things:
First is that if you manualy via command prompt log into datastage server and try the ODBC, it 's working. You can receive the data from SQL Server.
Second thing is that if you develope server job on a DataStage server on Windows platform and than job export/import to DataStage server on Linux platform it also works, but the statistics and some stuff is not working.
If you can help me, i'd be very greatfull.
KR, Bostjan
DataStage ODBC to SQL Server
Moderators: chulett, rschirm, roy
DataStage ODBC to SQL Server
KR, Bostjan
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: