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 maxRequestLength 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 maxRequestLength="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