ASP pages hangs up on IIS6.0

On web server when ASP pages hangs up - how to check what's cuasing it? Event viewer does not show any error. IIS services works ok - it displays HTML pages. But it stops pages which uses oledb/ odbc connection.

Restarting server fixes the probelm. As ASP pages hangs up it does not really show any error messsage to track it down. What can be done to get atleast the error message or why connection are getting hnaged?

Thanks in advance

IIS 6.0 and windows server 2003

First, I'd review the code in the asp page. Some bad code can hang. I don't have 2003, there may be some other issues.

One possibility is you have some antivirus script blocking running on the server or some firewall software interfering with asp.

If the problem is only related to DB calls make sure you haven't somehow corrupted the db drivers.

We changed code on major site - which hits more traffic to oledb connection. And used programming techniques suggested on aspmessageboard. Like closing connection as fast as can. getting all records in getrows..etc.

ASP pages hangs up every now and then, its like sometime twice a day and sometime it will work for 4 days with no problem.. So I think we will check out other possibilities you suggested about firewall, and anti virus.

Hi

i am in the same situation i had Fprot and no Firewall, i have remove it but i have the same problem, do u have fix it?

thx

The problem is we do even know what's cuasing it. there is not anti virus installed.

event viewer does not help as IIS services does not crash its just OLEDB/ODBC connections that is dynamic ASP pages hanges up.

One thing I've always noticed in this field sometime its just minor thing cuases this. But to figure out that issue takes the whole time in the world.

for eg: server variables in ASP. One of my collegue spent 2 days to figure out why its not working. coming to find out some ISP's does not allow server variables access. In no books they mention things like this which is kind of important I mena If I'm going to write a book 600+ pages.

Anyways hope we will able to find cuase. Its a nightmare.

If we find something I'll definitely post it on this board. Please do the same.

Thanks

ok, right now i have found that all the sites that use OLDdb have this problem and all the sites that use ODBC Dsn can work without any problem, so i think that there is only a problem how Win2003 manage the db connection

as you said I'm alos certain it has something to do with win server 2003 and db connection. I'm clueless what to do.

I greatly appreciate your post. Thanks

i have found this

http://support.microsoft.com/default.aspx?scid=kb;en-us;838306

we do have installed the latest hotfix avilable on MS website. But still it does hang up.

I wish MS would be more clear or specific on issue of this nature. Crashing the whole server can be counted as serious issue for the web hosting company.

http://support.microsoft.com/default.aspx?kbid=239114