Re: Question about max size of a dbrpcparam

has anyone run into this problem?

On Wed, Oct 1, 2008 at 11:58 AM, Navdeep Shergill <[email protected]>wrote:

> Hi
>      I am using v0.64RC2 of FreeTDS. I am trying to call a stored proc on
> SQL2005 server that takes in a image parameter. Here is my logic..
>
>             dbrpcparam(ldbproc,"@id",0,SYBCHAR,-1,strID.length(),idB);
>             dbrpcparam(ldbproc, "@table"
> ,0,SYBCHAR,-1,strTable.length(),focusB);
>             dbrpcparam(ldbproc, "@name"
> ,0,SYBCHAR,-1,strFileName.length(),nameB);
>             dbrpcparam(ldbproc, "@title"
> ,0,SYBCHAR,-1,strTitle.length(),titleB);
>             dbrpcparam(ldbproc, "@update"
> ,0,SYBCHAR,-1,updateFlag.length(),updateB);
>             dbrpcparam(ldbproc,"@content"
> ,0,SYBIMAGE,-1,numbytes,(BYTE*)memArea);
>             dbrpcsend(ldbproc)
>
>
> The image type is being fed with a byte pointer that holds the contents of
> a file. This thing works file as long as the file is of a smaller size. I
> have tried up to 30mb and it works fine. The problem happens when I try to
> pass in files larger than 35mb+. In that case; the dbrpcsend fails with a
> generic "Write to Sql Server Failed". My guess is that tds has a problem
> writing 35+mb out to the socket at once.
>
> I was wondering if anyone else has encountered this type of problem and if
> there is a solution?
>
>
> Thanks!
>
>