I have an issue when calling Oracle Stored Procedure from vbs. The vbs is scheduled using NT Task scheduler.

Now, the program stops when it called the Oracle Store Procedure from vbs. I have converted the vbs into ASP and it works fine. ie. Stored Procedure called successfully from ASP.

In one server, the scheduler task called the vbs and it works fine. In another 2 servers, it didn't call the procedure at all.

I am puzzled by all this. Do you have any idea?

Is it the account that used to run the NT Task scheduler play an important part?

The environment of executing the vbs and ASP is the same. The only different is vbs is run using Task Scheduler and ASP is run thru web page.

Pls advise.