Skip to Content.
Sympa Menu

freetds - [freetds] Question about MAX param size when calling StoredProc

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Navdeep Shergill" <jatshergill AT gmail.com>
  • To: freetds AT lists.ibiblio.org
  • Subject: [freetds] Question about MAX param size when calling StoredProc
  • Date: Mon, 19 May 2008 21:29:59 -0700

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!




Archive powered by MHonArc 2.6.24.

Top of Page