Oh, one other thing: we have two versions of the application, identical in every way except that our public version uses SSL (https://) and the private testing version does not (http://). The testing version of the site has never had this problem, although it also never has the volume of use...
When I first inherited this application, almost all of the recordsets were opening connections implicitly and that caused quite a few sleeping connections to build up on the SQL Server until IIS was restarted. Since then I've converted everything to explicitly open and then close all recordsets...
After searching the forums for a bit, I haven't found anything exactly like what's happening with my ASP pages, so I figured it wouldn't hurt to start a new thread.
I have an online application made up of ASP pages (IIS 5.0 on Windows 2000 Server) drawing data from a SQL Server database. Most...
Well, isn't this ironic. Not 30 seconds after I post this, I try one more thing to try to fix the problem, and it worked. Amazing how those things work out...
I just added the two subreports to this part of the code:
Sub ReportPaging()
'Retrieve the Records and Create the "Page on...
I've inherited an ASP-based online application that uses Crystal Reports 8.5 generated reports to display data from queries to SQL Server 7.0 stored procedures. We had been having problems with the application opening connections to the SQL Server implicitly and then never having them close...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.