Hi,
I'm using DAtastage 7.5.1.A, from documentation i can see that STP stage supports Sybase. I'm using STP stage to call a Sybase stored procedure, but while excecuting the job I'm getting the following error message,
Stored_Procedure_0: ct_connect
ServerNotFound
Could anyone tell me reason for this and also what should be given for "Data source name" and "Database name" in the General tab in STP stage properties.
Any help orsuggetions are greatly appreciated.
Thanks,
Jags
using STP stage with Sybase
Moderators: chulett, rschirm, roy
using STP stage with Sybase
REGARDS,
JAGS
JAGS
-
- Premium Member
- Posts: 37
- Joined: Wed Mar 23, 2005 5:20 am
-
- Participant
- Posts: 407
- Joined: Mon Jun 27, 2005 8:54 am
- Location: Walker, Michigan
- Contact:
I am able to use STP with Sybase. However, I have an open case with Ascential for over 1 year now because dscapiop does not function properly with the STP stage and causes tremendously slow performance when dealing with any significant amount of data. The current workaround is to use the Sybase OC stage. This same issue exists for all DBMS's that can be accessed via the STP stage.