Run VBScript Program

[Mighty]

Can anyone tell me how to fire a server side VBScript program from an ASP program. I want to run a script program to update a database table before the user runs a query. Mise Le Meas,

Mighty

 

[link9]

Mighty,

I **think** you have to do this with the wshell object. .run() method, in particular.

Here's a link to the .run() method:

http://www.devguru.com/Technologies/wsh/quickref/wshshell_Run.html

and for the entire object:

http://www.devguru.com/Technologies/wsh/quickref/wsh_intro.html

Seems like every time a question is asked of this nature, the answer always gets back to this object. Wish I could give better explanation, but I don't personally use it. Links should be helpful, though.


paul

 

[cfk]

If the VBScript program uses only ado and/or fso
then change it to an include file and run the
code directly in the asp page.
If you use the command shell object, or want to
run other external programs you may well find you have
problems with permissions.
You may also find that is the external program is rather heavy there is no code to send a 'Process Done' back to
your asp page, meaning any further statements in your asp
page may run before your external program has finnished.
Another options is to create an activeX/comm control to
be used server side.