Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > ASP General > Database access hangs

Reply
Thread Tools

Database access hangs

 
 
Bob Murdoch
Guest
Posts: n/a
 
      06-02-2004
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..


 
Reply With Quote
 
 
 
 
Aaron [SQL Server MVP]
Guest
Posts: n/a
 
      06-02-2004
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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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..
>
>



 
Reply With Quote
 
 
 
 
Aaron [SQL Server MVP]
Guest
Posts: n/a
 
      06-02-2004
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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> What type of connection are you making? What CursorType & LockType?

Sometimes playing with those settings can help...


 
Reply With Quote
 
Bob Murdoch
Guest
Posts: n/a
 
      06-02-2004
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..


 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Database Database Database Database scott93727@gmail.com Computer Information 0 09-27-2012 02:43 AM
DataBase DataBase DataBase DataBase scott93727@gmail.com Computer Information 0 09-26-2012 09:40 AM
ASP.NET Hangs While Opening A Connection To An Oracle Database s_valmont@telus.net ASP .Net 1 04-24-2007 10:15 PM
Gem hangs => TCPSocket.write hangs Tim Shadel Ruby 1 07-24-2005 06:11 AM
Clear hangs up - & hangs up - & hangs up Sue Bilstein NZ Computing 26 03-07-2004 01:33 AM



Advertisments