Originally posted by: Harinew2WTX

Hi ,

i need small help in WTX Database interface Designer .
while connecting to Database through WTX Database interface Designer i am getting below error message.
Error message : This application has failed to start because OCI.dll was not found . Re-installing the application may fix this problem .

anyone having idea on ths issue pls suggest me how to resolve it .
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender

Originally posted by: Myggiz

Hello

The database client need to be installed in order to do a direct connection to the database.

// Myggiz
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender

Originally posted by: KrishnaWTX

Hi , Even I face the same problem , in which the oci.dll cannot be found when we try to connect to the databse in Windows. However this is happening only when I try to execute the map using an launcher. The same map runs fine when I run it with the Command server (from design studio itself).

Also , the same system runs fine in our unix environment.

I would greatly appreciate if anyone helps me with the solution.

Thanks and Regards
Krishna
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender

Originally posted by: Kiran Kumar Reddy

Please make sure that the following environment variables are set to the oracle dir, in the environment from where you are executing the wtx maps.

$ORACLE_BASE
$ORACLE_HOME
$PATH
$LD_LIBRARY_PATH
$LIBPATH

If any of these variables are not set them and execute your maps. It should work.
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender