Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Community Forums
 Code Support: ASP (Non-Forum Related)
 Response Buffer Limit Exceeded
 New Topic  Topic Locked
 Printer Friendly
Next Page
Author Previous Topic Topic Next Topic
Page: of 2

kolucoms6
Average Member

845 Posts

Posted - 25 March 2008 :  20:31:21  Show Profile

Response object error 'ASP 0251 : 80004005' 

Response Buffer Limit Exceeded 

/debt/reports/Ann_Pop.asp, line 0 

Execution of the ASP page caused the Response Buffer to exceed its configured limit. 




What is this Error all about ?

Here goes below Code :








<%

Server.ScriptTimeOut=600
' ** SET IMP VARS HERE **
' ** END REALLY IMP VARS **
%>



<%

If session("AutoUserID")<>"" then

Dim adCn

Set adCn = Server.CreateObject("ADODB.Connection")
'adCn.Mode = 3      '3 = adModeReadWrite
adCn.Open session("connStr")

Response.write session("connStr")

Set adRsAnn=Server.CreateObject("ADODB.Recordset")		
sSql="Select * from Announcement where AutoUserID=" & session("AutoUserID")
'Response.write sSql
adRsAnn.Open sSql, session("cn")	

Response.write "<Table border=1>"

Do until adRsAnn.EOF

	Response.write "<tr><td><font color=Red size=1><b>" & adRsAnn("ADate") & "</td><td> " & adRsAnn("Announcement") & "</b></font></td></tr>"
        Response.Flush
	adRsAnn.MoveNext
Loop

Response.write "</Table>"
adRsAnn.Close
adCn.Close

End If
%>




Edited by - kolucoms6 on 25 March 2008 20:32:27

HuwR
Forum Admin

United Kingdom
20550 Posts

Posted - 26 March 2008 :  01:52:29  Show Profile  Visit HuwR's Homepage
it means exactly what it says, probably caused by your looping through the recordset (not a good idea anyway) and setting Server.ScriptTimeOut to 600 is very bad too.


due to the amount of questions you ask here I would strongly encourage you to either buy a good book or go on a coarse.
Go to Top of Page

kolucoms6
Average Member

845 Posts

Posted - 26 March 2008 :  07:23:47  Show Profile

Does it mean I shld Increase or at all remove

Server.ScriptTimeOut to 600 ?

Also, I didnt know that there is some restrictions on making number of post.

I post when I face any problem, thinking I may get the help in resolving.

Though I knew Internet is the best friend , after books.

Books can teach us how to code and write a program but all these Errors can be resolved while we gain some programming Experience.

Sorry If I hurt you.
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20550 Posts

Posted - 26 March 2008 :  07:41:16  Show Profile  Visit HuwR's Homepage
there is no limit no, but bear in mind this is actually a SNITZ support forum and therefor you may not get the answer you want/need if your question is not Snitz related.

you should not really be setting your script timeout to 600 seconds, if it requires that long to process your script then you have a major problem, and your host will not be very happy if you are tying up their server resources for that length of time.

to solve your issue, try getting your recordset into an array and then loop through the array rather than looping through the recordset.


if you learnt to code you perhaps wouldn't get so many errors that you needed to ask for a resolution
Go to Top of Page

pdrg
Support Moderator

United Kingdom
2897 Posts

Posted - 26 March 2008 :  09:53:21  Show Profile  Send pdrg a Yahoo! Message
I'm afraid I'm with Huw here, I reckon you'll really benefit from going on a course. The questions you're asking, whilst not basic, suggest your application is held together by Van der Walls forces and goodwill, and if it is a business-critical app you really need to get a solid structure/architecture in there.

Have you tried searching for that error message? http://support.microsoft.com/kb/925764 gives you a few options, and was a 10-second google away
Go to Top of Page

kolucoms6
Average Member

845 Posts

Posted - 26 March 2008 :  11:02:59  Show Profile

I tried Google and suggestion i got is to add

Response.Flush

I tried it but problem didnt get rersolve , thats why I posted it.
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20550 Posts

Posted - 26 March 2008 :  11:24:54  Show Profile  Visit HuwR's Homepage
well, not sure where you got that advise, but Response.flush does not clear the response buffer, it just sends it to the client quicker
Go to Top of Page

pdrg
Support Moderator

United Kingdom
2897 Posts

Posted - 26 March 2008 :  17:41:57  Show Profile  Send pdrg a Yahoo! Message
Response.flush can work, guess not this time. Instead try setting response.buffer = false right up at the very top of the page. An unbuffered response is less efficient in many ways, but the page will start rendering as you keep sending the huge data file to it. Give that a try, if it doesn't work, you've got a different problem, quite possibly your overall architecture causing sluggish responses/massive/odd datasets? It sounds like you might want to place a support call if that MSDN article doesn't help. If you bought non-OEM copies of the server software, you should have some support incidents available, or spend the few $ it is for a paid call, it'll save you time and money if it's an urgent problem.
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20550 Posts

Posted - 26 March 2008 :  17:59:52  Show Profile  Visit HuwR's Homepage
Response.flush is unlikely to work as many browsers won't render the table until the closing </TABLE> tag is received.
Go to Top of Page

kolucoms6
Average Member

845 Posts

Posted - 26 March 2008 :  18:22:06  Show Profile
Announcement table has only 6 records.

I am hosting/hosted with Godaddy.com

Let me try response.buffer = false
Go to Top of Page

Doug G
Support Moderator

USA
6493 Posts

Posted - 26 March 2008 :  22:11:32  Show Profile
Is google that difficult for you?

http://www.google.com/search?q=%22Response+Buffer+Limit+Exceeded%22&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-US:official&client=firefox-a

======
Doug G
======
Computer history and help at www.dougscode.com
Go to Top of Page

kolucoms6
Average Member

845 Posts

Posted - 26 March 2008 :  22:29:20  Show Profile
quote:

I tried Google and suggestion i got is to add

Response.Flush

I tried it but problem didnt get rersolve , thats why I posted it.

Go to Top of Page

AnonJr
Moderator

United States
5765 Posts

Posted - 27 March 2008 :  05:46:01  Show Profile  Visit AnonJr's Homepage
Yeah, we know you said you tried Google, but more suggestions came up than just the Response.Flush - things like checking the architecture, things like maybe only grabbing the columns you need instead of being lazy and using SELECT * - something that can potentially give you a huge recordset depending on your database structure.

These are all things that a good class in computer programming cover.

Edited by - AnonJr on 27 March 2008 05:46:28
Go to Top of Page

kolucoms6
Average Member

845 Posts

Posted - 27 March 2008 :  06:29:27  Show Profile

Looks like it my Provider i,.e Godaddy problem.

I tried the same page in another server and it works fine.
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20550 Posts

Posted - 27 March 2008 :  08:30:24  Show Profile  Visit HuwR's Homepage
that's the price you pay for free hosting (massively over loaded web servers)
Go to Top of Page

AnonJr
Moderator

United States
5765 Posts

Posted - 27 March 2008 :  09:17:13  Show Profile  Visit AnonJr's Homepage
There are enough decent hosts that are relatively inexpensive to make it worth spending the modest monthly fee. Prices vary depending on what you want and what options you get.

DON'T ask for recommendations (here or by e-mailing me) as this isn't a hosting forum and those discussions aren't allowed.

You could ask here for suggestions: http://www.webhostingtalk.com/
Go to Top of Page
Page: of 2 Previous Topic Topic Next Topic  
Next Page
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2019 Snitz™ Communications Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000 Version 3.4.07