Question about max size of a dbrpcparam

"Navdeep Shergill" <[email protected]>
Newsgroups gmane.comp.db.tds.freetds
Message-ID <[email protected]>
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!
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.