FreeTDS Development Group

["Lowden, James K" <LowdenJK AT bernstein.com>]

Good news:  I added "-h" to freebcp, to allow hints.  

Bad news:  bcp doesn't work for other reasons.

In testing freebcp with the Northwind database, I found we fail to process
the last token or so, and don't write the file.  Tail of dump attached,
beginning with the last received packet.  

--jkl

Received packet @ 2002-12-02 16:50:23.388531
0000  81 02 00 00 00 08 00 38  08 52 00 65 00 67 00 69   |.......8 .R.e.g.i|
0010  00 6f 00 6e 00 49 00 44  00 00 00 0a 00 ef 64 00   |.o.n.I.D ......d.|
0020  09 04 00 01 00 11 52 00  65 00 67 00 69 00 6f 00   |......R. e.g.i.o.|
0030  6e 00 44 00 65 00 73 00  63 00 72 00 69 00 70 00   |n.D.e.s. c.r.i.p.|
0040  74 00 69 00 6f 00 6e 00  d1 01 00 00 00 64 00 45   |t.i.o.n. .....d.E|
0050  00 61 00 73 00 74 00 65  00 72 00 6e 00 20 00 20   |.a.s.t.e .r.n. . |
0060  00 20 00 20 00 20 00 20  00 20 00 20 00 20 00 20   |. . . .  . . . . |
0070  00 20 00 20 00 20 00 20  00 20 00 20 00 20 00 20   |. . . .  . . . . |
0080  00 20 00 20 00 20 00 20  00 20 00 20 00 20 00 20   |. . . .  . . . . |
0090  00 20 00 20 00 20 00 20  00 20 00 20 00 20 00 20   |. . . .  . . . . |
00a0  00 20 00 20 00 20 00 20  00 20 00 20 00 20 00 20   |. . . .  . . . . |
00b0  00 20 00 d1 02 00 00 00  64 00 57 00 65 00 73 00   |. ...... d.W.e.s.|
00c0  74 00 65 00 72 00 6e 00  20 00 20 00 20 00 20 00   |t.e.r.n.  . . . .|
00d0  20 00 20 00 20 00 20 00  20 00 20 00 20 00 20 00   | . . . .  . . . .|
00e0  20 00 20 00 20 00 20 00  20 00 20 00 20 00 20 00   | . . . .  . . . .|
00f0  20 00 20 00 20 00 20 00  20 00 20 00 20 00 20 00   | . . . .  . . . .|
0100  20 00 20 00 20 00 20 00  20 00 20 00 20 00 20 00   | . . . .  . . . .|
0110  20 00 20 00 20 00 20 00  20 00 20 00 20 00 d1 03   | . . . .  . . ...|
0120  00 00 00 64 00 4e 00 6f  00 72 00 74 00 68 00 65   |...d.N.o .r.t.h.e|
0130  00 72 00 6e 00 20 00 20  00 20 00 20 00 20 00 20   |.r.n. .  . . . . |
0140  00 20 00 20 00 20 00 20  00 20 00 20 00 20 00 20   |. . . .  . . . . |
0150  00 20 00 20 00 20 00 20  00 20 00 20 00 20 00 20   |. . . .  . . . . |
0160  00 20 00 20 00 20 00 20  00 20 00 20 00 20 00 20   |. . . .  . . . . |
0170  00 20 00 20 00 20 00 20  00 20 00 20 00 20 00 20   |. . . .  . . . . |
0180  00 20 00 20 00 20 00 20  00 d1 04 00 00 00 64 00   |. . . .  ......d.|
0190  53 00 6f 00 75 00 74 00  68 00 65 00 72 00 6e 00   |S.o.u.t. h.e.r.n.|
01a0  20 00 20 00 20 00 20 00  20 00 20 00 20 00 20 00   | . . . .  . . . .|
01b0  20 00 20 00 20 00 20 00  20 00 20 00 20 00 20 00   | . . . .  . . . .|
01c0  20 00 20 00 20 00 20 00  20 00 20 00 20 00 20 00   | . . . .  . . . .|
01d0  20 00 20 00 20 00 20 00  20 00 20 00 20 00 20 00   | . . . .  . . . .|
01e0  20 00 20 00 20 00 20 00  20 00 20 00 20 00 20 00   | . . . .  . . . .|
01f0  20 00 20 00 d1 05 00 00  00 64 00 6a 00 6b 00 6c   | . ..... .d.j.k.l|
0200  00 20 00 20 00 20 00 20  00 20 00 20 00 20 00 20   |. . . .  . . . . |
0210  00 20 00 20 00 20 00 20  00 20 00 20 00 20 00 20   |. . . .  . . . . |
0220  00 20 00 20 00 20 00 20  00 20 00 20 00 20 00 20   |. . . .  . . . . |
0230  00 20 00 20 00 20 00 20  00 20 00 20 00 20 00 20   |. . . .  . . . . |
0240  00 20 00 20 00 20 00 20  00 20 00 20 00 20 00 20   |. . . .  . . . . |
0250  00 20 00 20 00 20 00 20  00 20 00 20 00 20 00 fd   |. . . .  . . . ..|
0260  10 00 c1 00 05 00 00 00                            |........|


2002-12-02 16:50:23.392099 processing result tokens.  marker is  81
2002-12-02 16:50:23.392245 processing row tokens.  marker is  0
2002-12-02 16:50:23.392360 inside tds_process_default_tokens() marker is 0
Unknown marker: 0(0)!!


The information contained in this transmission may contain privileged and
confidential information and is intended only for the use of the person(s)
named above.  If you are not the intended recipient, or an employee or agent
responsible for delivering this message to the intended recipient, any
review, dissemination, distribution or duplication of this communication is
strictly prohibited. If you are not the intended recipient, please contact
the sender immediately by reply e-mail and destroy all copies of the
original message. Please note that we do not accept account orders and/or
instructions by e-mail, and therefore will not be responsible for carrying
out such orders and/or instructions.