Response Buffer Limit Exceeded Help Needed

[Brian Piotrowski]

Hi All,

I have an SQL Server 2000 table that contains less than 2000 records. I
would like to select some of these records and group them. The query I
wrote runs fine in SQL Server's Query Analyzer, but when I run it in an ASP
page, I get:


Response object error 'ASP 0251 : 80004005'

Response Buffer Limit Exceeded

/test.asp, line 0

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

The line I am executing in ASP is this:

strSQL = "SELECT substring(BOS_data.mtoc,2,6) as 'MODEL',
count(substring(BOS_data.mtoc,2,6)) as 'Production' FROM BOS_data WHERE
BOS_data.plantcode =" & Request.querystring("pcode") & " and
pdate='08/27/2004' GROUP BY substring(BOS_data.mtoc,2,6)"

Like I said, it runs fine in SQL Server 2000. This code is running on a
Windows 2003 Server Web Edition Box under IIS6.0.

Any ideas would be appreciated.

Thanks,

Brian.