FreeTDS Development Group

["Kall, Bruce A." <kall AT mayo.edu>]

The problem I had arose from my use from PHP and phpmssql and not ODBC.
Everything works just fine with single result sets with php-mssql-4.3.10 
and freetds 0.62.4.  The problem arose with any result set > 1. If you 
want me to try some newer version please let me know.

Bruce




ZIGLIO, Frediano, VF-IT wrote:
> > 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
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds