Solved

VB is locking web server!!! ???

Posted on 2000-03-07
3
155 Views
Last Modified: 2010-05-02
Hello,

If a VB EXE is run from the web, does/can it take control away form the task manager. The program in question uses Excel and Powerpoint to make automated presentations from database data.  I get an error when trying to kill a hosed up Excel task saying I (the administrator) does not have permission to end the task.

Thanks
0
Comment
Question by:odium9
3 Comments
 

Expert Comment

by:AbbasAhmed
ID: 2592491
Could you be more specific about your problem. I mean I would like to know what platform you are using. What I guessed from your question is that you are running Windows 98/95. Well, as far as the VB exe problem is concerned, does this program work well if you execute it locally?
0
 

Author Comment

by:odium9
ID: 2592649
OK.. Sorry to be so vague.
The problem is under Windows NT 4.0 SP5.
I program works fine if executed locally.  The problem lies on test runs and running the program through links.  I force an error, and EXCEL gets hosed up in the servers Task Manager.  Then EXCEL and the program cannot be force closed by Task Manager.  After awhile, the whole server gets hosed.  I am guessing a message box appears, or something, but this process should still be able to be force closed.  

Hope that clarified.
0
 

Accepted Solution

by:
neoabacus earned 100 total points
ID: 2592956
because you are running in the context of the IIS user account which does not have interactive capabilities when you force an error a dialog box would normally be shown which you cannot respond to

since this is running in the confined context of the IIS server you cannot kill that process...(at least not as far as i am aware)

you may be able to stop the web service then kill the offending excel application..

however i find that the only sure way of stopping it is a reboot of NT...
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction While answering a recent question (http://www.experts-exchange.com/Q_27402310.html) in the VB classic zone, I wrote some VB code in the (Office) VBA environment, rather than fire up my older PC.  I didn't post completely correct code o…
This article describes some techniques which will make your VBA or Visual Basic Classic code easier to understand and maintain, whether by you, your replacement, or another Experts-Exchange expert.
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

685 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question