FreeTDS Development Group

[James Vanns <jimv AT canterbury.ac.uk>]

OK, here is the full dump:

Starting log file with debug level 99.
2003-08-05 14:51:34.502371 iconv will convert client-side data to the ""
character set
2003-08-05 14:51:34.502595 Connecting addr 5.0.8.210 port 1433 with TDS
version 8.0
2003-08-05 14:51:34.503463 inside tds_process_login_tokens()
Received header @ 2003-08-05 14:51:34.509384
0000  04 01 01 71 00 3b 01 00                            |...q.;..|


Received packet @ 2003-08-05 14:51:34.510624
0000  e3 1b 00 01 06 6d 00 61  00 73 00 74 00 65 00 72   |.....m.a
.s.t.e.r|
0010  00 06 6d 00 61 00 73 00  74 00 65 00 72 00 ab 62   |..m.a.s.
t.e.r..b|
0020  00 45 16 00 00 02 00 25  00 43 00 68 00 61 00 6e   |.E.....%
.C.h.a.n|
0030  00 67 00 65 00 64 00 20  00 64 00 61 00 74 00 61   |.g.e.d. 
.d.a.t.a|
0040  00 62 00 61 00 73 00 65  00 20 00 63 00 6f 00 6e   |.b.a.s.e .
.c.o.n|
0050  00 74 00 65 00 78 00 74  00 20 00 74 00 6f 00 20   |.t.e.x.t .
.t.o. |
0060  00 27 00 6d 00 61 00 73  00 74 00 65 00 72 00 27   |.'.m.a.s
.t.e.r.'|
0070  00 2e 00 06 48 00 55 00  4d 00 42 00 55 00 47 00   |....H.U.
M.B.U.G.|
0080  00 00 00 e3 08 00 07 05  09 04 d0 00 34 00 e3 17   |........
....4...|
0090  00 02 0a 75 00 73 00 5f  00 65 00 6e 00 67 00 6c   |...u.s._
.e.n.g.l|
00a0  00 69 00 73 00 68 00 00  ab 66 00 47 16 00 00 01   |.i.s.h..
.f.G....|
00b0  00 27 00 43 00 68 00 61  00 6e 00 67 00 65 00 64   |.'.C.h.a
.n.g.e.d|
00c0  00 20 00 6c 00 61 00 6e  00 67 00 75 00 61 00 67   |. .l.a.n
.g.u.a.g|
00d0  00 65 00 20 00 73 00 65  00 74 00 74 00 69 00 6e   |.e. .s.e
.t.t.i.n|
00e0  00 67 00 20 00 74 00 6f  00 20 00 75 00 73 00 5f   |.g. .t.o .
.u.s._|
00f0  00 65 00 6e 00 67 00 6c  00 69 00 73 00 68 00 2e   |.e.n.g.l
.i.s.h..|
0100  00 06 48 00 55 00 4d 00  42 00 55 00 47 00 00 00   |..H.U.M.
B.U.G...|
0110  00 ad 36 00 01 71 00 00  01 16 4d 00 69 00 63 00   |..6..q..
..M.i.c.|
0120  72 00 6f 00 73 00 6f 00  66 00 74 00 20 00 53 00   |r.o.s.o. f.t.
.S.|
0130  51 00 4c 00 20 00 53 00  65 00 72 00 76 00 65 00   |Q.L. .S.
e.r.v.e.|
0140  72 00 00 00 00 00 08 00  02 f8 e3 13 00 04 04 34   |r.......
.......4|
0150  00 30 00 39 00 36 00 04  34 00 30 00 39 00 36 00   |.0.9.6..
4.0.9.6.|
0160  fd 00 00 00 00 00 00 00  00                        |........ .|


2003-08-05 14:51:34.510833 inside tds_process_default_tokens() marker is
e3(ENVCHANGE)
2003-08-05 14:51:34.510881 inside tds_process_default_tokens() marker is
ab(INFO)
2003-08-05 14:51:34.510899 Msg 5701, Level 0, State 2, Server HUMBUG,
Line 0
Changed database context to 'master'.
2003-08-05 14:51:34.510914 inside tds_process_default_tokens() marker is
e3(ENVCHANGE)
2003-08-05 14:51:34.510970 inside tds_process_default_tokens() marker is
e3(ENVCHANGE)
2003-08-05 14:51:34.510985 inside tds_process_default_tokens() marker is
ab(INFO)
2003-08-05 14:51:34.511000 Msg 5703, Level 0, State 1, Server HUMBUG,
Line 0
Changed language setting to us_english.
2003-08-05 14:51:34.511014 inside tds_process_default_tokens() marker is
e3(ENVCHANGE)
2003-08-05 14:51:34.511029 increasing block size from 4096 to 4096
2003-08-05 14:51:34.511067 inside tds_process_default_tokens() marker is
fd(DONE)
2003-08-05 14:51:34.511119 inside tds_process_end() more_results = 0,
was_cancelled = 0 
2003-08-05 14:51:34.511133 inside tds_process_default_tokens() setting
state to COMPLETED
Sending packet @ 2003-08-05 14:51:34.511158
0000  01 01 00 22 00 00 01 00  73 00 65 00 6c 00 65 00   |..."....
s.e.l.e.|
0010  63 00 74 00 20 00 40 00  40 00 73 00 70 00 69 00   |c.t. .@.
@.s.p.i.|
0020  64 00                                              |d.|


2003-08-05 14:51:34.512080 processing result tokens.  marker is  0()
2003-08-05 14:51:34.512138 inside tds_process_default_tokens() marker is
0()
Unknown marker: 0(0)!!
2003-08-05 14:51:34.512158 tds_set_spid() failed
2003-08-05 14:51:34.512169 leaving tds_process_login_tokens() returning
0


What to I set the TDSDUMPCONFIG variable to? A file?

Cheers

Jim

On Tue, 2003-08-05 at 14:13, Thompson, Bill D (London) wrote:
> James,
> 
> Is this the full dump ?
> 
> Could you try setting the TDSDUMPCONFIG env variable and showing us the
> output.
> 
> Do you ever get a "Received packet" section in your dump ?
> 
> Bill
> 
> > -----Original Message-----
> > From:       James Vanns [SMTP:jimv AT canterbury.ac.uk]
> > Sent:       05 August 2003 12:43
> > To: FreeTDS Development Group
> > Subject:    [freetds] What the hell have I done!?
> > 
> > Hello (again!), thanks for all help previously but since I modified my
> > code the other day I can't even connect to the M$ SQL Server properly!
> > When trying to connect to the server using the TDS library it fails and
> > the dump log shows this:
> > 
> > Sending packet @ 2003-08-05 12:37:07.133714
> > 0000  01 01 00 22 00 00 01 00  73 00 65 00 6c 00 65 00   |..."....
> > s.e.l.e.|
> > 0010  63 00 74 00 20 00 40 00  40 00 73 00 70 00 69 00   |c.t. .@.
> > @.s.p.i.|
> > 0020  64 00                                              |d.|
> > 
> > 
> > 2003-08-05 12:37:07.134595 processing result tokens.  marker is  0()
> > 2003-08-05 12:37:07.134610 inside tds_process_default_tokens() marker is
> > 0()
> > Unknown marker: 0(0)!!
> > 2003-08-05 12:37:07.134628 tds_set_spid() failed
> > 2003-08-05 12:37:07.134639 leaving tds_process_login_tokens() returning
> > 0
> > 
> > Why would tds_set_spid() fail? Why should it suddenly start doing this!?
> > I havn't even changed the login code:
> > 
> > TDSSOCKET* login (TDSLOGIN *credentials) {
> >    TDSCONNECTINFO *info = NULL;
> >    TDSSOCKET *socket = tds_alloc_socket (context, BUFSIZ);
> > 
> >    if (!socket)
> >       return NULL;
> > 
> >    tds_set_parent (socket, NULL);
> >    info = tds_read_config_info (NULL, credentials, context->locale);
> > 
> >    if (!info)
> >       return NULL;
> > 
> >    if ((tds_connect (socket, info)) == TDS_FAIL)
> >       return NULL;
> > 
> >    tds_free_connect (info);
> > 
> >    return socket;
> > }
> > 
> > 
> > Thanks yet again!
> > 
> > Jim
> > 
> > -- 
> > James Vanns BSc (Hons) MCP
> > Linux Systems Administrator
> > Senior Software Engineer (Linux / C & C++)
> > Canterbury Christ Church University College
> > Public Key: http://pgp.mit.edu:11371/pks/lookup?op=get&search=0x24045370
> > 
> > _______________________________________________
> > FreeTDS mailing list
> > FreeTDS AT lists.ibiblio.org
> > http://lists.ibiblio.org/mailman/listinfo/freetds
> 
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
-- 
James Vanns BSc (Hons) MCP
Linux Systems Administrator
Senior Software Engineer (Linux / C & C++)
Canterbury Christ Church University College
Public Key: http://pgp.mit.edu:11371/pks/lookup?op=get&search=0x24045370