Running a vbs from ASP

[Stan Sainte-Rose]

Hi guys,

I would like to run a vbs script from an asp page.
I ve tried many directions but no one works..
The first was :
Dim oShell
Set oShell = Server.CreateObject("WSCript.shell")
i=oShell.run
("w:\wwwroot\look\j_consultation\j06_suivi\modules _stan\GenPDF.vbs 1 2 23,25
byAffaire N 1 FR st**@cyber97.com" )
Set oShell = Nothing

The second used AspExec componant
Set Executor = Server.CreateObject("ASPExec.Execute")
Executor.Application =
"w:\wwwroot\look\j_consultation\j06_suivi\modules_ stan\GenPDF.vbs"
Executor.Parameters = "1 2 23,25 byAffaire N 1 FR st**@cyber97.com"
resultat=Executor.ExecuteWinApp

Thanks for your help

Stan

[Patrice]

This is the same language. Depending on what the script does, you could
likely just include the VBS file and call the function it exposes ?

BTW, it doesn't work but what is the behavior you see ? You could try with a
very simple script to see if it's the call from ASP or the script itself
that fails.
"Stan Sainte-Rose" <st**@cyber972.com> a écrit dans le message de
news:ec**************@TK2MSFTNGP11.phx.gbl...

Hi guys,

I would like to run a vbs script from an asp page.
I ve tried many directions but no one works..
The first was :
Dim oShell
Set oShell = Server.CreateObject("WSCript.shell")
i=oShell.run
("w:\wwwroot\look\j_consultation\j06_suivi\modules _stan\GenPDF.vbs 1 2 23,25 byAffaire N 1 FR st**@cyber97.com" )
Set oShell = Nothing

The second used AspExec componant
Set Executor = Server.CreateObject("ASPExec.Execute")
Executor.Application =
"w:\wwwroot\look\j_consultation\j06_suivi\modules_ stan\GenPDF.vbs"
Executor.Parameters = "1 2 23,25 byAffaire N 1 FR st**@cyber97.com"
resultat=Executor.ExecuteWinApp

Thanks for your help

Stan

[Stan Sainte-Rose]

Hi Patrice,
In fact, with Aspexec, I get an "Access is denied" error..
About the vbs script, it generates a pdf doc and sends an email...

Any idea ?

Stan

--
"Patrice" <no****@nowhere.com> a écrit dans le message de news:
OD*************@TK2MSFTNGP11.phx.gbl...

This is the same language. Depending on what the script does, you could
likely just include the VBS file and call the function it exposes ?

BTW, it doesn't work but what is the behavior you see ? You could try with a very simple script to see if it's the call from ASP or the script itself
that fails.
"Stan Sainte-Rose" <st**@cyber972.com> a écrit dans le message de
news:ec**************@TK2MSFTNGP11.phx.gbl...

Hi guys,

I would like to run a vbs script from an asp page.
I ve tried many directions but no one works..
The first was :
Dim oShell
Set oShell = Server.CreateObject("WSCript.shell")
i=oShell.run
("w:\wwwroot\look\j_consultation\j06_suivi\modules _stan\GenPDF.vbs 1 2

23,25

byAffaire N 1 FR st**@cyber97.com" )
Set oShell = Nothing

The second used AspExec componant
Set Executor = Server.CreateObject("ASPExec.Execute")
Executor.Application =
"w:\wwwroot\look\j_consultation\j06_suivi\modules_ stan\GenPDF.vbs"
Executor.Parameters = "1 2 23,25 byAffaire N 1 FR st**@cyber97.com"
resultat=Executor.ExecuteWinApp

Thanks for your help

Stan

[Aaron [SQL Server MVP]]

So, is ASP running as IUSR or as an authenticated user? Might try to run as
the latter, or else make sure that IUSR has proper permissions on the EXE
that is used to create the PDF file, and the folder where the PDF file will
be output.

A typical workaround for this is to have the ASP page simply store the "job"
information in a table, and an executable or VBS script wakes up every five
minutes, and processes any new jobs that have been added. This way, the
executable can be run as an administrator or power user, instead of a very
limited anonymous user. Not immediate real-time, but for e-mailing a PDF it
is probably close enough.

--
http://www.aspfaq.com/
(Reverse address to reply.)


"Stan Sainte-Rose" <st**@cyber972.com> wrote in message
news:eV**************@TK2MSFTNGP12.phx.gbl...

Hi Patrice,
In fact, with Aspexec, I get an "Access is denied" error..
About the vbs script, it generates a pdf doc and sends an email...

Any idea ?

Stan

--
"Patrice" <no****@nowhere.com> a écrit dans le message de news:
OD*************@TK2MSFTNGP11.phx.gbl...

This is the same language. Depending on what the script does, you could
likely just include the VBS file and call the function it exposes ?

BTW, it doesn't work but what is the behavior you see ? You could try

with a

very simple script to see if it's the call from ASP or the script itself
that fails.
"Stan Sainte-Rose" <st**@cyber972.com> a écrit dans le message de
news:ec**************@TK2MSFTNGP11.phx.gbl...

Hi guys,

I would like to run a vbs script from an asp page.
I ve tried many directions but no one works..
The first was :
Dim oShell
Set oShell = Server.CreateObject("WSCript.shell")
i=oShell.run
("w:\wwwroot\look\j_consultation\j06_suivi\modules _stan\GenPDF.vbs 1 2

23,25

byAffaire N 1 FR st**@cyber97.com" )
Set oShell = Nothing

The second used AspExec componant
Set Executor = Server.CreateObject("ASPExec.Execute")
Executor.Application =
"w:\wwwroot\look\j_consultation\j06_suivi\modules_ stan\GenPDF.vbs"
Executor.Parameters = "1 2 23,25 byAffaire N 1 FR st**@cyber97.com"
resultat=Executor.ExecuteWinApp

Thanks for your help

Stan

[Stan Sainte-Rose]

Aaron,
Thanks for your reply..
It's exactly what I did :-)

Stan

--
---------------------------------------------------------------------
"Are you still wasting your time with spam?...
There is a solution!"

Protected by GIANT Company's Spam Inspector
The most powerful anti-spam software available.
http://mail.spaminspector.com
"Aaron [SQL Server MVP]" <te*****@dnartreb.noraa> a écrit dans le message de
news: eU**************@TK2MSFTNGP12.phx.gbl...

So, is ASP running as IUSR or as an authenticated user? Might try to run as the latter, or else make sure that IUSR has proper permissions on the EXE
that is used to create the PDF file, and the folder where the PDF file will be output.

A typical workaround for this is to have the ASP page simply store the "job" information in a table, and an executable or VBS script wakes up every five minutes, and processes any new jobs that have been added. This way, the
executable can be run as an administrator or power user, instead of a very
limited anonymous user. Not immediate real-time, but for e-mailing a PDF it is probably close enough.

--
http://www.aspfaq.com/
(Reverse address to reply.)


"Stan Sainte-Rose" <st**@cyber972.com> wrote in message
news:eV**************@TK2MSFTNGP12.phx.gbl...

Hi Patrice,
In fact, with Aspexec, I get an "Access is denied" error..
About the vbs script, it generates a pdf doc and sends an email...

Any idea ?

Stan

--
"Patrice" <no****@nowhere.com> a écrit dans le message de news:
OD*************@TK2MSFTNGP11.phx.gbl...

This is the same language. Depending on what the script does, you could likely just include the VBS file and call the function it exposes ?

BTW, it doesn't work but what is the behavior you see ? You could try

with

a

very simple script to see if it's the call from ASP or the script itself that fails.
"Stan Sainte-Rose" <st**@cyber972.com> a écrit dans le message de
news:ec**************@TK2MSFTNGP11.phx.gbl...
> Hi guys,
>
> I would like to run a vbs script from an asp page.
> I ve tried many directions but no one works..
> The first was :
> Dim oShell
> Set oShell = Server.CreateObject("WSCript.shell")
> i=oShell.run
> ("w:\wwwroot\look\j_consultation\j06_suivi\modules _stan\GenPDF.vbs 1 2 23,25
> byAffaire N 1 FR st**@cyber97.com" )
> Set oShell = Nothing
>
>
>
> The second used AspExec componant
> Set Executor = Server.CreateObject("ASPExec.Execute")
> Executor.Application =
> "w:\wwwroot\look\j_consultation\j06_suivi\modules_ stan\GenPDF.vbs"
> Executor.Parameters = "1 2 23,25 byAffaire N 1 FR st**@cyber97.com"
> resultat=Executor.ExecuteWinApp
>
> Thanks for your help
>
>
>
> Stan
>
>
>
>
>