[freetds] connect failed - (tds_set_spid() failed?)

Chris McDaniel Chris.McDaniel at telus.com
Thu Dec 19 14:57:07 EST 2002


Hi,

Here's the last bit of my trace - seems like it's connecting fine, as it
switches to the master DB and whatnot, but then drops.  This is today's cvs
snapshot - I could connect fine with 0.60, but upgraded because I could not
get stored procs to execute.  Anyone know why this fails?

Received packet @ 2002-12-19 16:49:51.828075
0000  e3 00 0f 01 06 6d 61 73  74 65 72 06 6d 61 73 74   |.....mas ter.mast|
0010  65 72 ab 00 3a 00 00 16  45 02 00 00 25 43 68 61   |er..:... E...%Cha|
0020  6e 67 65 64 20 64 61 74  61 62 61 73 65 20 63 6f   |nged dat abase co|
0030  6e 74 65 78 74 20 74 6f  20 27 6d 61 73 74 65 72   |ntext to  'master|
0040  27 2e 09 53 50 45 43 54  45 4c 42 53 00 00 00 ad   |'..SPECT ELBS....|
0050  00 1e 01 04 02 00 00 14  4d 69 63 72 6f 73 6f 66   |........ Microsof|
0060  74 20 53 51 4c 20 53 65  72 76 65 72 5f 06 32 ff   |t SQL Se rver_.2.|
0070  e3 00 09 04 03 35 31 32  03 35 31 32 fd 00 00 00   |.....512 .512....|
0080  00 00 00 00 00                                     |.....|


2002-12-19 16:49:51.829331 inside tds_process_default_tokens() marker is e3
2002-12-19 16:49:51.829712 inside tds_process_default_tokens() marker is ab
2002-12-19 16:49:51.830202 inside tds_process_default_tokens() marker is e3
2002-12-19 16:49:51.830536 inside tds_process_default_tokens() marker is fd
2002-12-19 16:49:51.830867 inside tds_process_end() more_results = 0,
was_cancelled = 0
2002-12-19 16:49:51.831186 inside tds_process_default_tokens() setting state
to COMPLETED
Sending packet @ 2002-12-19 16:49:51.831591
0000  01 01 00 15 00 00 00 00  73 65 6c 65 63 74 20 40   |........ select @|
0010  40 73 70 69 64                                     |@spid|


Received header @ 2002-12-19 16:49:51.892630
0000  04 01 00 22 00 00 00 00                            |..."....|


Received packet @ 2002-12-19 16:49:51.893005
0000  a0 00 01 00 a1 00 06 00  00 00 06 26 02 d1 02 00   |........ ...&....|
0010  13 fd 00 10 00 c1 00 00  00 01                     |........ ..|


2002-12-19 16:49:51.893468 processing result tokens.  marker is  a0
2002-12-19 16:49:51.893762 processing result tokens.  marker is  a1
2002-12-19 16:49:51.894092 processing result. type = 38(integer-null),
varint_size 1
2002-12-19 16:49:51.894418 tds_set_spid() failed
2002-12-19 16:49:51.894692 leaving tds_process_login_tokens() returning 0

Thanks,

Chris McDaniel





More information about the FreeTDS mailing list