buffer limit

M

middletree

Here's the error I am getting:
Response object error 'ASP 0251 : 80004005'
Response Buffer Limit Exceeded
Execution of the ASP page caused the Response Buffer to exceed its
configured limit

I then went to aspfaq.com, which told me to add the Response.Clear(), which
you'll see below. Since adding this, I get a timeout.


First, the connection:
strConnection ="Provider=Microsoft.Jet.OLEDB.4.0;Data
Source="&server.mappath(".\**.mdb")&";User Id=***;Password=***;"
filePath = Server.MapPath("***.mdb")

Next, the code, which queries one table in an Access database, and pulls a
city, state, name, and phone number, all of which are of type Memo:


<% Set objConnection = Server.CreateObject("ADODB.Connection")
objConnection.ConnectionString = strConnection
objConnection.Open

strSQL = "select State, City, BranchID, Phone, BranchName from CMMain "
Set RS = Server.CreateObject("ADODB.Recordset")
RS.Open strSQL, objConnection,1,1
Do While not rs.EOF
strState = rs("State")
strCity = rs("City")
strBranchID = rs("BranchID")
strPhone = rs("Phone")
strBranchName = rs("BranchName")
%>
<tr>
<td>
<%=strBranchName%>
</td>
<td>
<%=strCity%>
</td>
<td>
<%=strState%>
</td>
<td>
<%=strPhone%>
</td>
</tr>
<%
Response.Clear()
Loop
set rs = nothing
set ObjConnection = nothing
%>
 
M

middletree

Well, I changed:
Set RS = Server.CreateObject("ADODB.Recordset")

to

set RS = objConnection.execute (strSQL)


and it works now. I mean, I get a different error, but I will work on that.

Weird. I thought if I was pulling up a set of data, it has to be a
recordset.
 
D

Danny@Kendal

middletree said:
Here's the error I am getting:
Response object error 'ASP 0251 : 80004005'
Response Buffer Limit Exceeded
Execution of the ASP page caused the Response Buffer to exceed its
configured limit

I then went to aspfaq.com, which told me to add the Response.Clear(),
which you'll see below. Since adding this, I get a timeout.

I'm no expert but I hope the following might help.

I have a What's On page which uses the response buffer to hopefully speed
things up. The layout I use is something like this:

response.buffer=true
[open database]
[perform database query]
[response.write the values]
[close database connection]
response.flush
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,744
Messages
2,569,483
Members
44,902
Latest member
Elena68X5

Latest Threads

Top