FreeTDS Development Group

["Navdeep Shergill" <jatshergill AT gmail.com>]

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!