Stored procedures and freetds 0.52
Brian Bruns
camber at ais.org
Mon Jul 23 22:03:01 EDT 2001
On Mon, 23 Jul 2001, Alexander Celle T. wrote:
> Hi, how can I execute a stored procedure from linux/perl using freetds 0.52
> and DBD::Sybase 0.91 accesing MSSQL 7.0??
>
> I can do common selects without problems, but I cannot retrieve output
> parameters from stored procedures. Using Sybase openclient I did it with
>
If I understand you correctly, the stored procedure runs but the output
parameter is not being bound back to the host variable? This will take
some time to track down (quite a few components involved). What protocol
version are you using?
> but this doesn't work with freetds. You wonder why I want to change to
> freetds??
If OpenClient works for you then by all means use it, it is a well put
together product. FreeTDS does several things openclient does not (TDS7,
ODBC, wider platform support, pooling if I ever get time to finish it) and
of course there's the whole free software thing, but I'm just one guy
doing this in my spare time, so it is likely OpenClient will always be a
bit more polished and probably has fewer bugs to boot.
> I detected a possible memory leak in my program and I suspect it
> might be the driver. If you have a good memory debugging tool that could
> also help.
John Dumas did some checks for memory leaks just prior to 0.52 and they
were patched. I'm not aware of any outstanding leaks.
> Thanks for any help
> Alex
More information about the FreeTDS
mailing list