Skip to Content.
Sympa Menu

freetds - RE: [freetds] TEXT/NTEXT header format question

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Thompson, Bill D (London)" <bill_d_thompson AT ml.com>
  • To: "'FreeTDS Development Group'" <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] TEXT/NTEXT header format question
  • Date: Wed, 4 Feb 2004 07:38:14 -0000

David,

If you can send a couple example of the ROW message (0xd1) you are trying
to deconstruct, I'll take a look for you.
The preceding RESULTS message (0x81) would be useful as well.

Just a hex representation of this data will be fine.

I presume you're talking SQL 2000 (TDS 7/8)

Bill


> -----Original Message-----
> From: David Eastman [SMTP:deastman AT email.com]
> Sent: 03 February 2004 21:38
> To: freetds AT lists.ibiblio.org
> Subject: [freetds] TEXT/NTEXT header format question
>
> I've got a question I'm hoping someone here can help me with... I'm
> trying to parse TDS packets, and I'm having problems with TEXT/NTEXT
> columns. From the TDS source I've determined that bytes 25-28 of the
> column header are the length of the data, starting at byte 29.
> However, in certain queries, I'm finding that this length is off by a
> few bytes, which of course not only corrupts my column data, but
> means that I'm not picking up the next column correctly. I don't see
> anything in the TDS source to deal with this, and I've confirmed from
> some network captures that it is simply a case of the length bytes
> mentioned above not matching the actual text length, so obviously
> there must be some kind of offset or other information I'm missing.
> Does anyone have a clue? Is there a more up-to-date version of the
> protocol document that describes the column header for text columns?
> --
> ___________________________________________________________
> Sign-up for Ads Free at Mail.com
> http://promo.mail.com/adsfreejump.htm
>
> _______________________________________________
> 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