freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
- From: "Alex" <alexp AT vcidac.lv>
- To: freetds AT franklin.oit.unc.edu
- Subject: RE: Unknown marker: 165!!
- Date: Mon, 12 Aug 2002 14:41:59 -0400
> On Fri, 9 Aug 2002, Lowden, James K wrote:
>
> > > From: Alex [mailto:alexp AT vcidac.lv]
> > > Sent: August 9, 2002 1:48 PM
> > >
> > > Configuration: Freetds 0.60 (tried 4.2,7.0 protocols), MSSQL
> > > 7.0 server.
> > > The following query give away "Unknown marker: 165!!" message:
> > >
> > > DECLARE test_cursor CURSOR GLOBAL STATIC FOR SELECT * FROM testtable
> > > OPEN test_cursor
> > > FETCH NEXT FROM test_cursor
> >
> > Confirmed in sqsh with 8 August snapshot, see below. What should the
> > documentation say about server-side cursors? Do they work at all on MS
> > servers? I have only seen them work on Sybase.
>
> Actually we don't support cursors in sybase either, so...
>
> If we can get a tcpdump of a working cursor, we may be able to do
> something about it.
Quick and ugly hack did the trick. Simply ignore marker 165.
In token.c:
case 165:
tds_get_n(tds, NULL, tds_get_smallint(tds));
break;
Now fetch server-side cursors works without any errors (well, at least for
me).
-
Unknown marker: 165!!,
Alex, 08/09/2002
- <Possible follow-up(s)>
- RE: Unknown marker: 165!!, Lowden, James K, 08/09/2002
- RE: Unknown marker: 165!!, Alex, 08/09/2002
- RE: Unknown marker: 165!!, Brian Bruns, 08/09/2002
- RE: Unknown marker: 165!!, Alex, 08/12/2002
Archive powered by MHonArc 2.6.24.