DSXchange

Hi,
we are using oracle enterprise stage to access the data. In stage properties tab only user name and password options are enable and connection string option is not available.

when we trying to uase the view data we are getting the following error


Error executing view data command path search failure

There is more output available from the executing the server command

##I TFCN 000001 12:42:22(000) <main_program>
Ascential DataStage(tm) Enterprise Edition 7.5
Copyright (c) 2004, 1997-2004 Ascential Software Corporation.
All Rights Reserved


##I TOSH 000002 12:42:22(001) <main_program> orchgeneral: loaded
##I TOSH 000002 12:42:22(002) <main_program> orchsort: loaded
##I TOSH 000002 12:42:22(003) <main_program> orchstats: loaded
>##E TOSH 000205 12:42:23(000) <main_program> PATH search failure:
>##E TOSH 000000 12:42:23(001) <main_program> Error loading "orchoracle": Could not load "orchoracle": The specified module could not be found.
>##E TOSH 000000 12:42:23(002) <main_program> Could not locate operator definition, wrapper, or Unix command for "oraread"; please check that all needed libraries are preloaded, and check the PATH for the wrappers
>##E TCOS 000029 12:42:23(003) <main_program> Creation of step finished with status = FAILED

Can any one give idea to resolve this.

better you can use the odbc connection .it will solve your problem

gunabala wrote:better you can use the odbc connection .it will solve your problem

R u suggesting me to use ODBC stage inplace of oracle stage or providing the connecting string option in the properties tab os oracle ,if so the connection string option is not appearing in the properties tab of oracle.

if we take odbc stage it's work fine.

gunabala wrote:better you can use the odbc connection .it will solve your problem

R u suggesting me to use ODBC stage inplace of oracle stage or providing the connecting string option in the properties tab os oracle ,if so the connection string option is not appearing in the properties tab of oracle.

if we take odbc stage it's work fine.

If you search "orchoracle", you will find my detailed steps on how to solve this problem.