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.