I'm using IIS on W2k, using ODBC access to the database (which is on the
same server as IIS).
The system is designed to generate reports from users after they have walked
thru a few pages, supplying report parameters. The actual creation of the
report is done on another server, accomplished via a COM object that the web
server creates. This all works wonderfully.
However, after going thru this process, it seems the database connection
from the web server 'hangs', meaning any subsequent page requested from the
web server that has anything to do with the database will never complete,
and at this point never timeout either. My only solution is to reset the
IIS service.
At the point that the hanging occurs, I am still able to access the database
from other programs. I am able to access static pages on the web server. I
have looked at a number of performance counters under the ASP, IIS Globals,
and Web Service objects, but all show zero activity. Even the lowly Task
Manager shows nothing going on in the web server at all.
Is there anything I can check to see what is going on, what is being held
up?
tia,
Bob M.. 3 1743
Are you sure it isn't FileSystemObject? http://www.aspfaq.com/2180
Do you see event id 5 or 36 in your event log? http://www.aspfaq.com/2355 http://www.aspfaq.com/2226
Otherwise see http://www.aspfaq.com/2147
-- http://www.aspfaq.com/
(Reverse address to reply.)
"Bob Murdoch" <ra***********@erols.com> wrote in message
news:Od**************@TK2MSFTNGP11.phx.gbl... I'm using IIS on W2k, using ODBC access to the database (which is on the same server as IIS).
The system is designed to generate reports from users after they have
walked thru a few pages, supplying report parameters. The actual creation of the report is done on another server, accomplished via a COM object that the
web server creates. This all works wonderfully.
However, after going thru this process, it seems the database connection from the web server 'hangs', meaning any subsequent page requested from
the web server that has anything to do with the database will never complete, and at this point never timeout either. My only solution is to reset the IIS service.
At the point that the hanging occurs, I am still able to access the
database from other programs. I am able to access static pages on the web server.
I have looked at a number of performance counters under the ASP, IIS
Globals, and Web Service objects, but all show zero activity. Even the lowly Task Manager shows nothing going on in the web server at all.
Is there anything I can check to see what is going on, what is being held up?
tia,
Bob M..
Did you mean to reply to me? This is the second time I see so far... can
you please thread your message list, so that you reply to the original and
not a follow-up?
-- http://www.aspfaq.com/
(Reverse address to reply.)
"Scott Caldwell" <an*******@discussions.microsoft.com> wrote in message
news:4C**********************************@microsof t.com... What type of connection are you making? What CursorType & LockType?
Sometimes playing with those settings can help...
Aaron,
This is a tough one. Are you sure it isn't FileSystemObject?
Nope. Definitely not.
Do you see event id 5 or 36 in your event log?
Nope. No event messages other than the IIS reset.
Otherwise see
AspFaq is a great resource. It did mention a couple of last-chance updates
to make, just in case. So I went to Windows Update on the server first,
found a couple of security patches that hadn't been installed. I installed
those, and performed the requisite reboot. After the reboot, things seem to
be working correctly now. I highly doubt it was the security updates, most
likely just time for a reboot <g>.
Thanks for you help. I *really* hope this problem won't come back again.
Bob M.. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: szudor |
last post by:
Hi,
When I start db2cc, the program hangs with memory access violation in
javaw.exe. Strating with trace option, in java trace file I found the
following information:
0SECTION TITLE...
|
by: L Mehl |
last post by:
I tested a FE/BE application developed in A2000 on a A2002 machine and got
this message when exiting the app. Clicking the only available button "OK",
exits the application, as intended.
The FE...
|
by: Mr. Smith |
last post by:
Hello all,
My code can successfully open, write to, format and save several
worksheets in a workbook then save it by a given name, close and quit excel.
My problem is that if I try and do it...
|
by: Mike Knight |
last post by:
(I've also posted this problem on microsoft.public.excel.programming)
I have a MS Access 2003 Database named "AS400 Fields.mdb". This
database contains links to tables on an AS400.
In MS...
|
by: XXX |
last post by:
Hi,
I've got a problem with a damaged access 2000 database. When I try to repair
and compact the database, the process starts normaly, but then (after appr.
50 %) it hangs. Neither is it...
|
by: Vegar Hansen |
last post by:
Hello everone.
Can somebody help me?
When I run my code I can read, write to and delete from database, but when I
have done one of these things and try to copy the databasefile from my
folder...
|
by: rdemyan via AccessMonster.com |
last post by:
I don't understand why I can get the following to work:
------------------------------------------------------------------------------
--
SELECT A.*, B.* FROM TableA AS A, TableA AS B IN...
|
by: Wayne |
last post by:
I experienced the following problem the last time I installed IE7
beta. Since then I have done a reformat of my hard disc and after
using IE6 for a while I installed the latest version of IE7 and...
|
by: kscheu via AccessMonster.com |
last post by:
One of my users has Dell machine with 1 gb memory. Her access installation
seems to be corrupted. Her symptoms were sometimes when she tried to print a
report from an access application that I...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
| |