shelling an app on server from asp?

[Rich]

Hello,

I would like to turn on/invoke a VB6 app which resides on
the server/folder where IIS is running from an ASP page.
As for security, this would be all happening within an
intranet with firewall protection, etc, no outside
internet access. In pseudocode of my asp app I am
thinking like this:

<%
....
RetVal = Shell("../myApp.exe " & someArg, vbNormalFocus)
....
%>

I would like to be able to invoke myApp from anywhere
within my company. Is it doable what I would like to do?
And if so, if my pseudo code above is not going to work,
may I request if someone could share the correct method?

Thanks,
Rich

[Tom Kaminski [MVP]]

"Rich" <an*******@disc ussions.microso ft.com> wrote in message
news:01******** *************** *****@phx.gbl.. .

Hello,

I would like to turn on/invoke a VB6 app which resides on
the server/folder where IIS is running from an ASP page.

http://www.aspfaq.com/show.asp?id=2059

--
Tom Kaminski IIS MVP
http://www.iistoolshed.com/ - tools, scripts, and utilities for running IIS
http://mvp.support.microsoft.com/
http://www.microsoft.com/windowsserv...y/centers/iis/

[Rich]

Thank you very much for the web address. This is very
helpful.

Rich

-----Original Message-----
"Rich" <an*******@disc ussions.microso ft.com> wrote in messagenews:01******* *************** ******@phx.gbl. ..

Hello,

I would like to turn on/invoke a VB6 app which resides on the server/folder where IIS is running from an ASP page.
http://www.aspfaq.com/show.asp?id=2059

--
Tom Kaminski IIS MVP
http://www.iistoolshed.com/ - tools, scripts, and

utilities for running IIShttp://mvp.support.microsoft.com/
http://www.microsoft.com/windowsserv...ommunity/cente rs/iis/
.

[Rich]

Well, I went and tried the code sample from the webpage
below. This code did invoke myApp from the ASP as I could
see it in the Windows Task Manager as running, but myApp
was not visible when invoked from the ASP. I tried the
same code from a .vbs file, and myApp was visible. Is
there a way to make myApp visible when invoking from the
ASP?

Thanks,
Rich

-----Original Message-----
"Rich" <an*******@disc ussions.microso ft.com> wrote in messagenews:01******* *************** ******@phx.gbl. ..

Hello,

I would like to turn on/invoke a VB6 app which resides on the server/folder where IIS is running from an ASP page.
http://www.aspfaq.com/show.asp?id=2059

--
Tom Kaminski IIS MVP
http://www.iistoolshed.com/ - tools, scripts, and

utilities for running IIShttp://mvp.support.microsoft.com/
http://www.microsoft.com/windowsserv...ommunity/cente rs/iis/
.

[Tom Kaminski [MVP]]

"Rich" <an*******@disc ussions.microso ft.com> wrote in message
news:06******** *************** *****@phx.gbl.. .

Well, I went and tried the code sample from the webpage
below. This code did invoke myApp from the ASP as I could
see it in the Windows Task Manager as running, but myApp
was not visible when invoked from the ASP. I tried the
same code from a .vbs file, and myApp was visible. Is
there a way to make myApp visible when invoking from the
ASP?

That's because when launched from ASP, the app is running under the
context/desktop of the web server. Is it really practical to run that kind
of app from a web server? What are you trying to do?

--
Tom Kaminski IIS MVP
http://www.iistoolshed.com/ - tools, scripts, and utilities for running IIS
http://mvp.support.microsoft.com/
http://www.microsoft.com/windowsserv...y/centers/iis/

[Rich]

I have to pull data into a Sql Server on this server 2 or
3 times a week (1,000,000+ records) from another
datasource within my company. I have been requested to
automate this process. I was thinking about having a
webpage someone could bring up within the company intranet
and send parameters to my app which would invoke the data
pulling apps.

Another trick I was thinking about was to just pass data
to the app's let properties. In MS access I can make a
reference to the App and then say Set x = New myApp,
x.letParm1 = #9/1/03#. I can also instantiate myApp with
CreateObject("m yAppProj.class1 ") from vbs (or Access).
But I like to have the app just running and use GetObject,
and then pass data to it. I was not able to use GetObject
(, "myAppProj.clas s1") in my test vbs file. Is there a
way I could write directly to myApp while it is running
from asp/vbs? I can do that from ms Access, how to do it
from script?

I realize that there are several ways I could pass data to
the server, and just have myApp polling for messages or
textfiles, and I could even send an argument with
parameters with wsShell.run "myApp.exe " & #9/1/03#, and
it does not have to be visible. But I would rather have
myApp running visibly and be able to pass/write data to it
which would show up like in a textbox. How can I
reference myApp from asp/vbs like in ms Access or use
GetObject so that I could write/pass data directly to the
running instance of myApp?

Thanks,
Rich

-----Original Message-----
"Rich" <an*******@disc ussions.microso ft.com> wrote in messagenews:06******* *************** ******@phx.gbl. ..

Well, I went and tried the code sample from the webpage
below. This code did invoke myApp from the ASP as I could see it in the Windows Task Manager as running, but myApp
was not visible when invoked from the ASP. I tried the
same code from a .vbs file, and myApp was visible. Is
there a way to make myApp visible when invoking from the
ASP?
That's because when launched from ASP, the app is running

under thecontext/desktop of the web server. Is it really practical to run that kindof app from a web server? What are you trying to do?

--
Tom Kaminski IIS MVP
http://www.iistoolshed.com/ - tools, scripts, and utilities for running IIShttp://mvp.support.microsoft.com/
http://www.microsoft.com/windowsserv...ommunity/cente rs/iis/
.

[Bob Barrows]

Rich wrote:

I have to pull data into a Sql Server on this server 2 or
3 times a week (1,000,000+ records) from another
datasource within my company. I have been requested to
automate this process. I was thinking about having a
webpage someone could bring up within the company intranet
and send parameters to my app which would invoke the data
pulling apps.

Why not use the builtin SQL Server capabilities? You can use SQL Agent to
schedule a DTS package to run periodically.

Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[Rich]

(you asked for it :) I have to pull data from a Lotus
Notes Domino Server (actually 4 of them). The datasets I
am pulling contain like 200 fields a piece and like
300,000+ records apiece. The fields can contain any
manner of data, and more times than not people have
entered characters that are not ascii based or recognized,
etc. So I have a VB app which pulls this data and cleans
up unacceptable characters, and writes nice clean ascii
text to my sql server tables and in sql I have sp's that
converts dates back to date format, etc. Maybe DTS could
do all this too, and I'm sure I should purchase a book on
DTS, but I haven't. Truth is, I just don't see how DTS
could pull data from a Lotus Notes DB since Notes is
document based (as opposed to relational). I was hoping I
could pass parameters to my pulling app (day and time to
pull data) and also read back timestamp data from when
data was pulled back to the asp. I have noticed that I
can invoke my app from asp, but I can't seem to write data
to the disk from my app when called by asp (I'm sure that
is a feature of asp - maybe not?) I am looking to use set
x = GetObject("c:\s omedir\myApp.ex e"), x.letParam=...

and soforth. The alternative would be to load an app on
each workstation that needs to deal with this project. I
just thought that planting a hyperlink on the desktop
would have been a lot easier with just one app on the
server. Any comments appreciated (can I use GetObject in
asp?).

Thank you again for your reply.
Rich

-----Original Message-----
Rich wrote:

I have to pull data into a Sql Server on this server 2 or 3 times a week (1,000,000+ records) from another
datasource within my company. I have been requested to
automate this process. I was thinking about having a
webpage someone could bring up within the company intranet and send parameters to my app which would invoke the data pulling apps.
Why not use the builtin SQL Server capabilities? You can

use SQL Agent toschedule a DTS package to run periodically.

Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my Fromheader is my spam trap, so I don't check it very often. You will get aquicker response by posting to the newsgroup.
.

[Rich]

OK. Someone at my place just gave me a great idea (so
simple!). Write my paramters to an Access mdb with ADO.
Let Access manipulate my pulling programs. I would never
have thought of this because this is just too easy :).
This guy also mentioned that I need to step up to .Net
(which is already at my disposal).

I thank everyone for your responses to my posts.
Rich

-----Original Message-----
Hello,

I would like to turn on/invoke a VB6 app which resides on
the server/folder where IIS is running from an ASP page.
As for security, this would be all happening within an
intranet with firewall protection, etc, no outside
internet access. In pseudocode of my asp app I am
thinking like this:

<%
....
RetVal = Shell("../myApp.exe " & someArg, vbNormalFocus)
....
%>

I would like to be able to invoke myApp from anywhere
within my company. Is it doable what I would like to do?And if so, if my pseudo code above is not going to work,
may I request if someone could share the correct method?

Thanks,
Rich
.

[keyur shah]

Yes, its doable...

Keyur Shah
Verizon Communications
732-423-0745

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!