[freetds] Problem with stored proc and varchar parameters
bflood at tethermedia.com
bflood at tethermedia.com
Thu Jul 13 21:44:57 EDT 2006
Thanks. The problem was in the application. I was setting the ColumnSize
in the SQLBindParameter call to 0 as oppose to the proper length. Once I
set it properly it all worked. The same code worked on windows so I guess
windows treats it differently.
Anyway thanks for the pointer to the rpc.c unittest. That was a big help
in helping me track down my problem.
>> From: bflood at tethermedia.com
>> Sent: Thursday, July 13, 2006 2:04 PM
>> Where can I get the 0.63 tgz. The website only seems to have stable
>> and latest snapshot.
> I'll tell you where you can find 0.63, but first want to advise you. I
> disagree that 0.64 cannot send parameters to stored procedures. Among
> other things, FreeTDS's ODBC driver is used with DBD::ODBC and
> OpenOffice.org. If varchar parameters were really a problem, we'd be
> very concerned.
> And if you *do* have a problem, you're unlikely to get help with 0.63
> from the developers at this point.
> Please look in src/odbc/unittests and see samples/odbc_rpc.pl. If
> you're sure you're coding your application correctly, please provide as
> small a test case as you can, perhaps by modifiying one of the
> I just finished writing src/odbc/unittests/rpc.c. It's only in current
> CVS; you can find it in any current snapshot. If you simply build the
> snapshot (and don't install it), then run "make check" in
> src/odbc/unittests, then try "ldd rpc", I think you'll see that it's
> linked to your *installed* libraries. If so, I would think that would
> be a good harness for you. I tested it with 0.64 and it worked as of a
> few days ago.
> (I actually think the unit tests should be statically linked to the
> build tree, but in this case what I consider a bug could be more of a
> Now I'll answer your question. On http://www.freetds.org/software.html
> (the software link on the main page) you'll see "Ibiblio.org Main
> distribution site". Click there and go to the "old" directory. It's a
> positive gold mine of obsolete code.
>> > bflood at tethermedia.com wrote:
>> >> Hi,
>> >> I am new to freetds. I just downloaded stable version (0.64)
>> >> yesterday and have a simple ODBC app that I am trying to get
>> >> working on linux (connecting to SQL Server on a windows box).
>> >> I have a stored proc that takes a varchar (basically a string
>> >> of up to 10 chars). However when I execute it no character data
>> >> gets sent across the wire. If I change the proc to take an
>> >> INTEGER then it works (and I see the parm value in the TDS
>> >> stream).
>> > Try version 0.63 I had the same problem with 0.64, going back to
>> > 0.63 solved the problem. Perhaps also read this:
>> > http://kb.vankoperen.nl/freetds-problems.html
> The information contained in this transmission may be privileged and
> confidential and is intended only for the use of the person(s) named
> above. If you are not the intended recipient, or an employee or agent
> for delivering this message to the intended recipient, any review,
> distribution or duplication of this communication is strictly prohibited.
> If you are
> not the intended recipient, please contact the sender immediately by reply
> and destroy all copies of the original message. Please note that we do not
> account orders and/or instructions by e-mail, and therefore will not be
> for carrying out such orders and/or instructions. If you, as the intended
> of this message, the purpose of which is to inform and update our clients,
> and consultants of developments relating to our services and products,
> would not
> like to receive further e-mail correspondence from the sender, please
> "reply" to the
> sender indicating your wishes. In the U.S.: 1345 Avenue of the Americas,
> New York,
> NY 10105.
> FreeTDS mailing list
> FreeTDS at lists.ibiblio.org
More information about the FreeTDS