Menu
I am running a simple query to get data out of my database & display them. I'm getting an error that says Response Buffer Limit Exceeded.
Error is : Response object error 'ASP 0251 : 80004005'
Response Buffer Limit Exceeded
/abc/test_maintenanceDetail.asp, line 0
Execution of the ASP page caused the Response Buffer to exceed its configured limit.
I have also tried Response.flush in my loop and also use response.buffer = false in my top of the page, but still I am not getting any data.
My database contains 5600 records for that, Please give me some steps or code to solve the issue.
941
Response Buffer Size governs how many rows are returned from the Advanced SQL Engine back to a client in one Response. For example, roughly about 81 rows will fit into one Response when the row size is 100 bytes and the Response Buffer size is set to 8192 bytes.
The Buffer property indicates whether to buffer page output. When page output is buffered, the server does not send a response to the client until all of the server scripts on the current page have been processed, or until the Flush or End method is called.
You can use the AspBufferingOn IIS metabase property to enable or disable buffering at the application level. In IIS 7 and later versions, you can enable or disable ASP response buffering at the application level by using the bufferingOn value in the ASP section of <System. webserver> in the ApplicationHost.
I know this is way late, but for anyone else who encounters this problem: If you are using a loop of some kind (in my case, a Do-While) to display the data, make sure that you are moving to the next record (in my case, a rs.MoveNext).
79
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
