I've got the following problem.I have a ASP report which generate reports based on data collected by a VB.NET program into SQL2000 Database server.I have no problems running the reports on a smaller amount of data but if I'd like to run a report on the last 3 months this will involve millions of entries which will need to be handled by the querry.
If I run the querrie from Querry Analyzer I have no problem getting the recordset (which is my report basically).As soon as I try to run th every same query from the ASP interface through IE then I will have the following error.:error text=Timeout expired (Microsoft OLE DB Provider for SQL Server).
I've changed my asp code so it will display the error and this is what I get plus the whole query as in the picture.I increased the timeout in the SQL Server itself ,I did increase it in IIS and I also increased the objConnectionConnectionTim
eout = 0 .I really don't know of any other setting and the location of that setting where I could increase it to infinity.I am happy to wait as much time It takes to run the code.Please help I am totally stuck.