Hello everyone,

I am trying to execute a vbs file which would read a text file and insert into the database.

I have an asp page with form controls and when i submit, in the process page have to execute the vbs file. have been trying to use
WShShell = Server.CreateObject("WScript.Shell") and run the file but not happening.

Can anyone help me out with this??

CODE:

dim WShShell, RetCode
Set WShShell = Server.CreateObject("WScript.Shell")
RetCode = WShShell.Run("D:\Project\website\admin\MigratePric eList.vbs",1, True)
response.write RetCode
set WShShell = nothing

Thank you
Krishna Kumar

Hi,

It probably isn't working because the Internet User account doesn't have the right permissions and giving it the right permissions would represent a security risk.

I'd write a flag to a database table and then set the Windows Scheduler to run the vbs every 5 minutes or so - in the vbs you initially poll the database table and if the flag is set you carry on running the rest of your script, if not you exit until next invoked by the Scheduler.

http://www.thewebsiteshop.co.uk