Error while conneting to sybase

dsguy · Post by **dsguy** » Fri Nov 17, 2006 1:10 pm

Hi

The following error is encountered while connecting to Sybase from DataStage.Please help me in resolving the same

PCS_INIT_EXTR..Initial_Extract: ct_connect failed
There is no entry for server 'server.uta.com' in the Sybase client configuration file or DCE directory source. Use the Sybase dsedit or dsedit_dce utility to configure access to this server.
PCS_INIT_EXTR....Initial_Extract.DSLink1: DSP.Open GCI $DSP.Open error -100.

Thanks in advance for ur help

Thanks,
Girish

ray.wurlod · Post by **ray.wurlod** » Fri Nov 17, 2006 1:25 pm

Welcome aboard. :D

Read the error message.
It is not a DataStage problem.
Your Sybase connectivity has not been configured.

dsguy · Post by **dsguy** » Fri Nov 17, 2006 1:35 pm

Thanks Ray
We could connect to the sybase from Sybase client connection tool SQL Advantage but we are not able to connect from the DataStage.

Sybase server is up and running fine.

Does it required to configure anything from the Datastage Server? appreciate your quick solution.

ray.wurlod wrote:Welcome aboard. :D

Read the error message.
It is not a DataStage problem.
Your Sybase connectivity has not been configured.

Ultramundane · Post by **Ultramundane** » Fri Nov 17, 2006 2:33 pm

You must install the Sybase Open Client software on each node and edit $SYBASE/interfaces to add the aliases and network addresses for the servers you want to access.

ray.wurlod · Post by **ray.wurlod** » Fri Nov 17, 2006 2:38 pm

You may (will) also need to assign values to your SYBASE environment variables in the DataStage dsenv script.