| Author |
 Topic  |
|
kolucoms6
Average Member
845 Posts |
 Posted - 25 March 2008 : 20:31:21
|
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
20579 Posts |
Posted - 26 March 2008 : 01:52:29
|
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. |
 |
|
|
kolucoms6
Average Member
845 Posts |
Posted - 26 March 2008 : 07:23:47
|
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.
|
|
|
|
HuwR
Forum Admin
United Kingdom
20579 Posts |
Posted - 26 March 2008 : 07:41:16
|
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 |
|
|
|
pdrg
Support Moderator
United Kingdom
2897 Posts |
Posted - 26 March 2008 : 09:53:21
|
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 |
|
|
|
kolucoms6
Average Member
845 Posts |
Posted - 26 March 2008 : 11:02:59
|
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.
|
|
|
|
HuwR
Forum Admin
United Kingdom
20579 Posts |
Posted - 26 March 2008 : 11:24:54
|
| 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 |
|
|
|
pdrg
Support Moderator
United Kingdom
2897 Posts |
Posted - 26 March 2008 : 17:41:57
|
| 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. |
|
|
|
HuwR
Forum Admin
United Kingdom
20579 Posts |
Posted - 26 March 2008 : 17:59:52
|
| Response.flush is unlikely to work as many browsers won't render the table until the closing </TABLE> tag is received. |
|
|
|
kolucoms6
Average Member
845 Posts |
Posted - 26 March 2008 : 18:22:06
|
Announcement table has only 6 records.
I am hosting/hosted with Godaddy.com
Let me try response.buffer = false |
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
|
|
kolucoms6
Average Member
845 Posts |
Posted - 26 March 2008 : 22:29:20
|
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.
|
|
|
|
AnonJr
Moderator
United States
5765 Posts |
Posted - 27 March 2008 : 05:46:01
|
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 |
|
|
|
kolucoms6
Average Member
845 Posts |
Posted - 27 March 2008 : 06:29:27
|
Looks like it my Provider i,.e Godaddy problem.
I tried the same page in another server and it works fine. |
|
|
|
HuwR
Forum Admin
United Kingdom
20579 Posts |
Posted - 27 March 2008 : 08:30:24
|
| that's the price you pay for free hosting (massively over loaded web servers) |
|
|
|
AnonJr
Moderator
United States
5765 Posts |
Posted - 27 March 2008 : 09:17:13
|
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/ |
|
|
|
Topic |
|
Topic Locked
