FreeTDS Development Group

[Brian Bruns <camber AT ais.org>]

It is possible for a single query to generate multiple result sets.  The
would particularly happen when calling stored procedures.  I'd have to
defer to the jdbc people on how freetds/jdbc handles this, but we have not
had any problem with 'spurious' result sets on the C side of things.

Brian

On Wed, 15 Nov 2000, [ISO-8859-1] "Sch?rk, Andreas" wrote:

> Hello,
> I?m only working with jdbc, but perhaps the others know something about it
> as well.
> I had big Problems after doing much work on one Tds-Connection because of
> not expected responses.
> Until I noticed that sometimes 2 result-sequences come after one sending. 
> The second one has been interpreted as the result of the next sending, until
> a resultset was
> expected and I got an error.
> My solution is to look always before starting a new Packet whether there is
> anything left on the incoming 
> stream and remove it first.
> 
> Has anybody a explanation for this,  Could it be related to a SQLError which
> occured before ?
> Did you in the C-Project already solve this ?
> 
> Andreas
>