Unknown marker: 165!!

Alex alexp at vcidac.lv
Mon Aug 12 15:41:59 EDT 2002


> 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).



More information about the FreeTDS mailing list