4 MB Limit Will Not Go Away

[Mark]

Thanks in Advance.

I encountered the 4 MB limit recently while using the export feature of
Crystal Reports version 9 Report Application Server which uses a MS SQL
Server 2000 as a data source. The data being export out of the report
into MS Excel is around 4100 KB. The RAS and IIS 6 is on Server A,
while the SQL Server is on Server B. The report is requested from an
IE 6.0 brower session on workstation A.

I have found posts suggesting that the 4 MB limit can be changed in
both the machine.config and the web.config files. I made the following
changes, and none of them have removed the limit.

1. I changed the value in the machine.config file on the Server A in
httpRuntime maxRequestLengt h from 4096 to 8192. Attempted report, no
luck.
2. I restarted IIS 6 on Server A. Attempted report, no luck.
3. I restarted Server A. Attempted report, no luck.
4. I added the following to the web.config file on Server A:
<httpRuntime maxRequestLengt h="8192" /> Attempted report,
no luck.
5. I restarted IIS 6 a second time on Server A. Attempted report, no
luck.
6. I restarted Server A a second time. Attempted report, no luck.

I cannot think of a logical reason why this limit would be controlled
at the SQL Server. My workstation A machine.config file has only two
httpRuntime entries which refer to publickeytokens , so I am refraining
from making changes there until instructed otherwise.

Please help.

Mark Simmerman
Napa, California