I have an asp page that calls a component developed using vb6 to handle database access. The page creates and online report. The query is a long running one (just over 5 minutes). I know that is huge but I have no choice to remove this report.
The problem is that when we changed to windows 2003 and iis 6, the asp page never completes. I can use and older server running iis 5 and it works fine. Using IE7 the tab has the spinning circle and says connecting. At the bottom the browser says it is waiting for http://????? where the question marks are just the address of the page. Using component services I can see that the component begins processing and a little over 5 minutes later appears to complete it work. This appears the same regardless of using iis 5 or 6. Even though the compent has completed running the query the page never finishes loading. I've set the keep-alive, connection time-outs and script time-outs to give plenty of time. i've tried a registry setting on the client that is supposed to tell IE7 to increase the keep-alive as well. I don't received any error messages in the brower, IIS logs, event viewer, or our compontents error log. I can't tell if the component is having trouble getting the data back to iis or if iis is just never sending the data back to the browser.
Also, if I have the page create the report for a shorter running query it works fine.
I assume I am just missing some simple setting but can't figure out what it could be. Any help would be greatly appreciated.
Thanks.