varbinary(MAX) object stream

Question

0.00/5 (No votes)

See more:

SQL-Server-2008R2

hi everybody,
i want to ask how can i upload MP3 file to sql database with size between 30-60 MB. i was implement web application that uploaded file but after completing i revived message that operation failed because file size to big!

how can i resolve this problem.
PS: i identifies the database parameter as varbinary(MAX) object stream

regards

Posted 14-Mar-15 8:34am

Badour alsamaraie

Add a Solution

Comments

Dave Kreskowiak 14-Mar-15 16:00pm

Well, the varbinary(max) limit is 2^31 - 1 bytes, about 2GB so that's not your problem.

The exact error message and the code that throws it is required here.

George Jonsson 14-Mar-15 21:46pm

Have you tried with some smaller files, say 30KB, 300KB, 3MB etc?
It might help you to find a specific limit and give clues to further trouble shooting.

Badour alsamaraie 15-Mar-15 2:10am

i was uploaded small file like 1Mb to 4MB and there is no problem but when i am upload file of 43 MB i receive this error:

HTTP Error 404.13 - Not Found
The request filtering module is configured to deny a request that exceeds the request content length.

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Badour alsamaraie · Answer 1 · 2015-03-14T22:06:00

thanks all i resolve the problem by adding script to web.config :

XML

<system.webServer>
     <modules runAllManagedModulesForAllRequests="true" />
     <security>
       <requestFiltering>
         <requestLimits maxAllowedContentLength="2147483647"></requestLimits>
       </requestFiltering>

     </security>

and set http max execution runtime to 7200:

<httpruntime maxrequestlength="100000" executiontimeout="7200" />

varbinary(MAX) object stream

1 solution

Solution 1

Add your solution here

Preview 0

varbinary(MAX) object stream

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us