Skip to Content.
Sympa Menu

freetds - RE: Unknown marker: 165!!

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • 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).




Archive powered by MHonArc 2.6.24.

Top of Page