Current Position:Home > Running workbook from .bat fails to start application missing CORE40 dll

Running workbook from .bat fails to start application missing CORE40 dll

Update:10-11Source: network consolidation
Advertisement
I have been running several workbook via windows task scheduler / vbscript &/or bat files.
I now have a new box which I access thru Remote Desktop Connection, so I can run all these automated updates without having my screen blinking everytime a shedule workbook starts.
If I click on the actual Discoverer icon, or the discoverer workbook shortuct, all works well.
If I click on the .bat file, or try to run the workbook via the cmd , it gives me the following error:
DIS4USR.EXE – Unable To Locate Component
“this application has failed to start because CORE40.DLL was not found. Re-installing the application may fix this problem.”
The dll is under c/orant/bin/core40.dll, which is where I've read it should be, and it works fine in my regular box...
Please help! URGENT :)
Thanks!

The Best Answer

Advertisement
Hello
Check the PATH environment variables for the machine you are on and the one you are connecting to.
You might not have Discoverer's objects in the PATH.
Another possibility is that you have more than one piece of ORACLE software on the machine and you may need to also set the ORACLE_HOME within the BAT file.
Best wishes
Michael