Re: Start service with VB

Billy Verreynne wrote:
>scotty wrote:
>
>> Here's my priorities;
>> 1) allowing laughing boy to start and stop Oracle remotely
>> 2) not leaving my room wide open at all hours
>> 3) finishing an oracle college assignment
>
>The CGI solution should fit this nicely.

Yeah it's ideal being as Apache is bundled with Oracle, i'll have a play with it later and see if I can get it up and running. I've only ever set up an IIS server, so the experience will be new...

>> You just don't like VB do you, come on admit it.
>
>Whatever did I say to give you that idea!?

VB receives a bad press but it's managed to pay my way through college over the last 7 months so I can't slag it off too much. Having said that, i've gone back to coding in C++ at college and now i'm suffering from all the bad habits i've developed. Encapsulation... pfffft... never heard of it...

>>>--
>>>@echo off
>>>echo.Content-Type: text/html;
>>>echo.
>>>echo.
>>>..rest of the cmd file
>>>--
>>>
>>>Maybe also throw in a <PRE> and </PRE> before and after the shell command,
>>>as this will correctly format the STDOUT output.
>
>Oh yeah... forgot to mention how to get the < and > chars into a CMD script.
>Microsoft again messed up with the way their command shell parser works.
>These chars are redirection symbols - even when enclosed in quotes.
>
>Something like this should do the trick:
>--
>@echo off
>echo.Content-Type: text/html;
>echo.
>echo.^<PRE^>
>echo.Oracle Service Startup results:
>net start OracleServiceNameGoesHere
>echo.^<PRE^>
>--
>
>Ditto for the net stop script. There are likely more than one service you
>need to start (been a while since I used Oracle on NT). I would think that
>the you need to start the basic Oracle service, the Oracle Listener, and
>then also perform the database startup.
>
>These can take a while to run, thus the student may think that the CGI is
>hanging. Another option is to put the NET START bits into another CMD file
>that does the complete startup of all services and mounts and opens the
>database. Then you call that CMD file from the CGI using the START command.
>This will run the startup CMD file as a batch/background job. The CGI will
>return a response immediately that this background startup job has been
>started.

Ok, thanks again...

>BTW, did I tell you how crappy VB is?

Get some penicillin, that'll clear it up... Received on Thu Nov 21 2002 - 10:59:46 CST