FreeTDS Development Group

["ZIGLIO, Frediano, VF-IT" <Frediano.Ziglio AT vodafone.com>]

> 
> From: Kall, Bruce A.
> Sent: Monday, May 16, 2005 9:00 AM
> 
> Has there been any progress in 0.64 on the error with
> stored procedures that return more than one result set?
> 
> Your message is in reply to a db-lib buffering issue.  Frankly I don't
> remember offhand what was wrong with it, but I know it's fixed.  
> 
> Your question seems to relate to an ODBC issue, whereby ODBC has
> difficulties with stored procedures containing a sequence like:
> 
>       SELECT <something>
>       RAISERROR <about something>
>       SELECT <something else>
> 
> 0.62.3 drops the RAISERROR output. Later versions concatenate 
> the result
> sets.  I'm not sure what the current status is.  I know Frediano has
> been working on it.  
> 
> --jkl
> 

Bruce reported an error for result set (fixed in 0.62.4 and 0.63) and a
problem using buffering (certainly fixed in CVS).
The raiserror problem has been fixed however using different DM you can
have sligtly different behavior (I think unixOBDC can "eat" the
message).

Currently I'm working on:
- constant parameter (now encoded only as varchar, Sybase do not like
this...)
- array binding, fetch should work but test is missing (to fix problem
with OTL library), parameter does not work at all (noone complained but
can be a good improvement even for performance)
- dblib thread safing (still waiting for some comments from Liam)
I would like to merge datacopy with some fixes and implement support for
OpenSSL (not only GnuTLS).

freddy77