Freako Freako - 2 years ago 123
SQL Question

Error during Execution of File Upload

During the execution of project at the Image upload time, Browser is displaying this error.
I am using SQl Server as Database.

`Server Error in '/' Application.
Maximum request length exceeded.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Web.HttpException: Maximum request length exceeded.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[HttpException (0x80004005): Maximum request length exceeded.]
System.Web.HttpRequest.GetEntireRawContent() +9803702
System.Web.HttpRequest.GetMultipartContent() +63
System.Web.HttpRequest.FillInFormCollection() +160
System.Web.HttpRequest.EnsureForm() +69
System.Web.HttpRequest.get_Form() +13
System.Web.HttpRequest.get_HasForm() +9800635
System.Web.UI.Page.GetCollectionBasedOnMethod(Boolean dontReturnNull) +95
System.Web.UI.Page.DeterminePostBackMode() +69
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +220
Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.6.1073.0`

Is there any restriction limit During file Upload for SQl Server?

Answer Source

This error is raised by your web server and not by SQL server.

If you are using IIS, you can modify your web.config to allow large file uploads.

        <httpRuntime maxRequestLength="xxxxxx" />

For IIS version 7 and above, use the following..

         <requestLimits maxAllowedContentLength="xxxxxxx" />

The above example is taken from here

Also, please read this.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download