ASP/IIS Loses SQL Server Connection Randomly

[MrFurious]

Hi everyone,

I have an ASP application that accesses (through ODBC) a SQL Server 2000 database. Sometimes IIS will stop talking to SQL server. All the ASP pages that access data will hang without an error or timeout. In SQL server I see a connection from IIS whose last batch is one of my stored procedures. It's always the same procedure. That connection in SQL server won't clear until I reset the web server. Everything works just fine after the server is reset.

I have reproduced the problem only twice by clicking on a link and then quickly closing the browser window.

Has anyone ever had such a problem? It happens at least a couple times a day and I can't seem to figure out why.

Thank You,

Mike

PS Sorry if this is the wrong forum. ASP, IIS, SQL Server if I knew where the problem was I prolly woulda fixed it by now.

 

[palbano]

Mike, this sounds like a tough one. I would try SQL Server forum next if no one has any help here.

Have you looked in the error logs?

-pete

 

[Webwench]

Did you ever figure this out? I have a similar issue. I've put the offending ASP into high isolation, which helps to contain the symptoms, but still can not determine the cause.

 

[MrFurious]

Hey Wench,

No, I never figured it out. I even swallowed my pride and called Microsoft. They reviewed my asp and didn't have any problem with my code. They did have me switch to OLE DB but that didn't help. They looked at the stored procedures in SQL server and didn't find any problem with those. They wanted to look at a memory dump next but I never game them the chance. I had to go on vacation so I put the asp app on my XP workstation. I just moved it without changing anything and it works fine. For some reason it just didn't want to sit on the same machine. Fortunately I only have a few users so I don't run into the connection limit for IIS on XP.

-Mike