aspSmartUpload Download Problem

I am getting the following error:

Error Type:
ADODB.Field (0x800A0BB9)
Arguments are of the wrong type, are out of acceptable range, or are
in conflict with one another.


When this code snippet is executed.

<%
Set mySmartUpload =
Server.CreateObject("aspSmartUpload.SmartUpload")

mySmartUpload.DownloadField objRS("FileData")
%>

objRS("FileData") is an 'Image' datatype field in a sql server
database. It contains the image of a Microsoft Word document.

This code works perfectly when that word document is a relatively
small document. When the doc gets to be larger than 10 mb, the
download produces the error shown above.

Does anybody know of a work around or how to configure for larger
files?

Re: aspSmartUpload Download Problem

david@davesaconsulting.com wrote:
> I am getting the following error:
>
> Error Type:
> ADODB.Field (0x800A0BB9)
> Arguments are of the wrong type, are out of acceptable range, or are
> in conflict with one another.
>
>
> When this code snippet is executed.
>
> <%
> Set mySmartUpload =
> Server.CreateObject("aspSmartUpload.SmartUpload")
>
> mySmartUpload.DownloadField objRS("FileData")
> %>
>
> objRS("FileData") is an 'Image' datatype field in a sql server
> database. It contains the image of a Microsoft Word document.
>
> This code works perfectly when that word document is a relatively
> small document. When the doc gets to be larger than 10 mb, the
> download produces the error shown above.
>
> Does anybody know of a work around or how to configure for larger
> files?

You could try to tweak this value:
http://technet2.microsoft.com/WindowsServer/en/library/3cbbd 4b3-36d3-40fb-9fea-abbdf1805cf91033.mspx

In fact, the aspSmartUpload documentation advises this on IIS6.



--
Dave Anderson

Unsolicited commercial email will be read at a cost of $500 per message. Use
of this email address implies consent to these terms.

Re: aspSmartUpload Download Problem

"Dave Anderson" wrote in message
news:esqhheIqHHA.3888@TK2MSFTNGP05.phx.gbl...
> david@davesaconsulting.com wrote:
> > I am getting the following error:
> >
> > Error Type:
> > ADODB.Field (0x800A0BB9)
> > Arguments are of the wrong type, are out of acceptable range, or are
> > in conflict with one another.
> >
> >
> > When this code snippet is executed.
> >
> > <%
> > Set mySmartUpload =
> > Server.CreateObject("aspSmartUpload.SmartUpload")
> >
> > mySmartUpload.DownloadField objRS("FileData")
> > %>
> >
> > objRS("FileData") is an 'Image' datatype field in a sql server
> > database. It contains the image of a Microsoft Word document.
> >
> > This code works perfectly when that word document is a relatively
> > small document. When the doc gets to be larger than 10 mb, the
> > download produces the error shown above.
> >
> > Does anybody know of a work around or how to configure for larger
> > files?
>
> You could try to tweak this value:
>
http://technet2.microsoft.com/WindowsServer/en/library/3cbbd 4b3-36d3-40fb-9fea-abbdf1805cf91033.mspx
>
> In fact, the aspSmartUpload documentation advises this on IIS6.
>

That setting affects the maximum size of upload whereas in this case the
SmartUpload component is being used to perform a download.

It's more likely this one is needed:-

http://technet2.microsoft.com/windowsserver/en/library/3cbbd 4b3-36d3-40fb-9fea-abbdf1805cf91033.mspx?mfr=true

AspBufferLimit controls the size of the response buffer. OTH assuming
aspSmartUpload chunks the output to the response simply using
Response.Buffer = false may fix it.





>
>
> --
> Dave Anderson
>
> Unsolicited commercial email will be read at a cost of $500 per message.
Use
> of this email address implies consent to these terms.
>
>

Re: aspSmartUpload Download Problem

Anthony Jones wrote:
> That setting affects the maximum size of upload whereas in this
> case the SmartUpload component is being used to perform a download.

So it is. In either case, a metabase setting seems a likely factor.



--
Dave Anderson

Unsolicited commercial email will be read at a cost of $500 per message. Use
of this email address implies consent to these terms.

Re: aspSmartUpload Download Problem

I have tried changing both ASPMaxRequestEntityAllowed and
ASPBufferingLimit. I also set Response.Buffering = false.

Unfortunately this has not resolved the problem.