Skip to Content.
Sympa Menu

freetds - Re: [freetds] SQLCancel() anderror diagnostic: Expecting HY008SQLSTATE

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "ZIGLIO, Frediano, VF-IT" <Frediano.Ziglio AT vodafone.com>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] SQLCancel() anderror diagnostic: Expecting HY008SQLSTATE
  • Date: Wed, 16 Jan 2008 17:33:08 +0100

>
> humm... maybe stupid remark:
>
> It returns success because it's a sp_* call and not direct SQL?
>
> Seb
>

Yes and no... server reply just after cancel... very unlikely. Also you
will note that statement id is 0x0abcdef0... it seems a dummy values but
sp_unprepare like this handle. I have to try if it like always this
handle (that is is a really dummy handle), what happen calling
sp_cursorfetch on this handle and if I use an invalid handle.

freddy77


> ZIGLIO, Frediano, VF-IT wrote:
> >> Ok, I could reproduce the new problem:
> >>
> >> I don't get SQLSTATE=HY008 when using server-side cursors...
> >>
> >> Try attached sample to reproduce.
> >>
> >> Seb
> >>
> >
> > ??? why server reply success ???
> >
> > freddy77
> >
> >
> >
> >
> --------------------------------------------------------------
> ----------
> >
> > _______________________________________________
> > FreeTDS mailing list
> > FreeTDS AT lists.ibiblio.org
> > http://lists.ibiblio.org/mailman/listinfo/freetds
>
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>




Archive powered by MHonArc 2.6.24.

Top of Page