I am facing a different kind of issue, which is giving the below error,
Microsoft OLE DB Provider for SQL Server error '80040e21'
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
/CISL/Web/Calls/BNTANT Response Time/BNTResponseTime_Graph.asp, line 246
The stored procedure involved is used to generate a report based on days range ( like 30 days, 60 days, 90 & 180 days)
The procedure which i execute in this asp page is executing fine when i execute from Query analyser. But the issue is the error is thrown when i select 180 days range and that too only when i run it first time from front end. If i run the second time it works fine from then on.
If i run the 60 days report first and try the 180 days report second time, it works fine.
If i try first the 180 days report after a long time (of 1 to 2 hrs) it gives error.
Could any one help me on this ASAP?
Many Thanks in Advance!!!