Question about MAX param size when calling StoredProc

"Navdeep Shergill" <[email protected]>
Newsgroups gmane.comp.db.tds.freetds
Message-ID <[email protected]>
Hi . I am using v0.82 of the freeTDS library. I am trying to call to call a
storedProc on a SQL2005 server that takes in a 'varbinary' field as input
paramter. The varbinary field is set up with '-1' as the Length in the
database. Here are the steps that I am doing.

1. Call dbrpcinit
2. Call dbrpcparam for each parameter
3. Call dbrpcsend
4. Call dbsqlok
5. Process all results with dbresults()


The problem that I am seeing is that for the 'varbinary' field; only 8000
chars are getting into the DB. Is that some sort of a limitation in FreeTDS?
Has anyone run into this particular issue before.

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.