Skip to Content.
Sympa Menu

freetds - Re: [freetds] help: unexpected token 117 and sybase server hanged

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Re: [freetds] help: unexpected token 117 and sybase server hanged

Chronological Thread  
    < Chronological >       < Thread >
  • From: Mai Le <maile AT ScienceVIEW.lhs.Berkeley.EDU>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] help: unexpected token 117 and sybase server hanged
  • Date: Fri, 5 Sep 2003 14:16:58 -0700 (PDT)

I have included the tdslog . Thanks for any help

On 5 Sep 2003, Frediano Ziglio wrote:

> Il ven, 2003-09-05 alle 01:12, Mai Le ha scritto:
> > Hi all,
> >
> > I am trying to connect tothe Sybase server(NT 4.0) running ASA 6.0.x (I
> > think
> > it's 6.0.3) from a Linux box running
> > Apache 1.3.27
> > Red Hat 7.3
> > PHP 2.4.3
> > freetds 0.61
> > I am also using TDS version 5.0 to connect to sybase.
> >
> > When connecting via tsql : I get this message:
> > Msg 21, Level 10, State 0, Server , Line 0
> > TDS: unexpected token 117
> >
> > If I connect via php, it will says that it is connected but shortly
> > after that, the sybase machine would hang.
> >
> > Any help would be greatly appreciated.
> >
>
> Hi!
> This message came directly from Sybase so I expect we send some garbage
> to server. Enable log (see TDSDUMP in User Guide) and send output dump
> (use temporary account for security).
>
> freddy77
>
>
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>
Starting log file for FreeTDS 0.61.2 with debug level 99.
2003-09-05 14:09:47.360079 iconv will convert client-side data to the ""
character set
2003-09-05 14:09:47.360238 Connecting addr 128.xxx.xxx.xxx port 2639 with TDS
version 4.2
Sending packet @ 2003-09-05 14:09:47.368683
0000 02 00 02 00 00 00 00 00 73 63 69 00 6e 63 65 76 |........ sciencev|
0010 69 65 77 33 2e 6c 68 73 2e 42 65 72 6b 65 6c 65 |xxxxxxxx .xxxxxxx|
0020 79 2e 45 44 55 00 00 63 00 00 72 65 61 00 00 00 |y.EDU..c xxxxxx..|
0030 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |........ ........|
0040 00 00 00 00 00 07 63 63 00 00 01 00 00 00 00 00 |......xxxxxx.....|
0050 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |........ ........|
0060 00 00 00 00 05 33 37 38 37 36 00 00 00 00 00 00 |.....378 76......|
0070 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |........ ........|
0080 00 00 00 05 03 01 06 0a 09 01 00 00 00 00 02 00 |........ ........|
0090 00 00 00 00 54 53 51 4c 00 00 00 00 00 00 00 00 |....TSQL ........|
00a0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |........ ........|
00b0 00 00 04 43 43 54 00 00 00 00 00 00 00 00 00 00 |...xxx.. ........|
00c0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |........ ........|
00d0 00 03 00 63 00 70 00 00 00 00 00 00 00 00 00 00 |..xxxxx. ........|
00e0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |........ ........|
00f0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |........ ........|
0100 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |........ ........|
0110 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |........ ........|
0120 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |........ ........|
0130 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |........ ........|
0140 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |........ ........|
0150 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |........ ........|
0160 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |........ ........|
0170 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |........ ........|
0180 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |........ ........|
0190 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |........ ........|
01a0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |........ ........|
01b0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |........ ........|
01c0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |........ ........|
01d0 00 05 04 02 00 00 54 44 53 2d 4c 69 62 72 61 72 |......TD S-Librar|
01e0 0a 00 00 00 00 00 0d 11 75 73 5f 65 6e 67 6c 69 |........ us_engli|
01f0 73 68 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |sh...... ........|


Sending packet @ 2003-09-05 14:09:47.368950
0000 02 01 00 4c 00 00 00 00 00 00 00 00 00 00 0a 00 |...L.... ........|
0010 00 00 00 00 00 00 00 00 00 00 00 00 00 49 53 4f |........ .....ISO|
0020 2d 38 38 35 39 2d 31 35 00 00 00 00 00 00 00 00 |-8859-15 ........|
0030 00 00 00 00 00 00 00 00 00 00 00 0b 01 35 31 32 |........ .....512|
0040 00 00 00 03 00 00 00 00 00 00 00 00 |........ ....|


2003-09-05 14:09:47.369005 inside tds_process_login_tokens()
Received header @ 2003-09-05 14:09:47.377721
0000 04 00 00 09 00 00 00 00 |........|


Received packet @ 2003-09-05 14:09:47.377739
0000 ad |­|


Received header @ 2003-09-05 14:09:47.377757
0000 04 00 00 0a 00 00 00 00 |........|


Received packet @ 2003-09-05 14:09:47.377776
0000 22 00 |".|


Received header @ 2003-09-05 14:09:47.378097
0000 04 00 00 09 00 00 00 00 |........|


Received packet @ 2003-09-05 14:09:47.378114
0000 05 |.|


Received header @ 2003-09-05 14:09:47.378128
0000 04 00 00 0c 00 00 00 00 |........|


Received packet @ 2003-09-05 14:09:47.378144
0000 04 02 00 00 |....|


Received header @ 2003-09-05 14:09:47.378406
0000 04 00 00 09 00 00 00 00 |........|


Received packet @ 2003-09-05 14:09:47.378423
0000 18 |.|


Received header @ 2003-09-05 14:09:47.378437
0000 04 00 00 20 00 00 00 00 |... ....|


Received packet @ 2003-09-05 14:09:47.378453
0000 41 64 61 70 74 69 76 65 20 53 65 72 76 65 72 20 |Adaptive Server |
0010 41 6e 79 77 68 65 72 65 |Anywhere|


Received header @ 2003-09-05 14:09:47.378477
0000 04 00 00 0c 00 00 00 00 |........|


Received packet @ 2003-09-05 14:09:47.378494
0000 06 00 00 00 |....|


Received header @ 2003-09-05 14:09:47.378757
0000 04 00 00 09 00 00 00 00 |........|


Received packet @ 2003-09-05 14:09:47.378773
0000 aa |ª|


2003-09-05 14:09:47.378789 inside tds_process_default_tokens() marker is
aa(ERROR)
Received header @ 2003-09-05 14:09:47.378804
0000 04 00 00 0a 00 00 00 00 |........|


Received packet @ 2003-09-05 14:09:47.378833
0000 25 00 |%.|


Received header @ 2003-09-05 14:09:47.378849
0000 04 00 00 0c 00 00 00 00 |........|


Received packet @ 2003-09-05 14:09:47.378865
0000 15 00 00 00 |....|


Received header @ 2003-09-05 14:09:47.378879
0000 04 00 00 09 00 00 00 00 |........|


Received packet @ 2003-09-05 14:09:47.378895
0000 00 |.|


Received header @ 2003-09-05 14:09:47.378922
0000 04 00 00 09 00 00 00 00 |........|


Received packet @ 2003-09-05 14:09:47.378938
0000 0a |.|


Received header @ 2003-09-05 14:09:47.378952
0000 04 00 00 0a 00 00 00 00 |........|


Received packet @ 2003-09-05 14:09:47.378980
0000 19 00 |..|


Received header @ 2003-09-05 14:09:47.378997
0000 04 00 00 21 00 00 00 00 |...!....|


Received packet @ 2003-09-05 14:09:47.379014
0000 54 44 53 3a 20 75 6e 65 78 70 65 63 74 65 64 20 |TDS: une xpected |
0010 74 6f 6b 65 6e 20 31 31 37 |token 11 7|


Received header @ 2003-09-05 14:09:47.379036
0000 04 00 00 09 00 00 00 00 |........|


Received packet @ 2003-09-05 14:09:47.379052
0000 00 |.|


Received header @ 2003-09-05 14:09:47.379282
0000 04 00 00 09 00 00 00 00 |........|


Received packet @ 2003-09-05 14:09:47.379298
0000 00 |.|


Received header @ 2003-09-05 14:09:47.385537
0000 04 00 00 0a 00 00 00 00 |........|


Received packet @ 2003-09-05 14:09:47.385566
0000 00 00 |..|


Received header @ 2003-09-05 14:09:47.385685
0000 04 00 00 09 00 00 00 00 |........|


Received packet @ 2003-09-05 14:09:47.385719
0000 fd |ý|


2003-09-05 14:09:47.385730 inside tds_process_default_tokens() marker is
fd(DONE)
Received header @ 2003-09-05 14:09:47.385744
0000 04 00 00 0a 00 00 00 00 |........|


Received packet @ 2003-09-05 14:09:47.385760
0000 03 00 |..|


2003-09-05 14:09:47.385771 inside tds_process_end() more_results = 1,
was_cancelled = 0
Received header @ 2003-09-05 14:09:47.385783
0000 04 00 00 0a 00 00 00 00 |........|


Received packet @ 2003-09-05 14:09:47.385799
0000 01 00 |..|


Received header @ 2003-09-05 14:09:47.385813
0000 04 01 00 0c 00 00 00 00 |........|


Received packet @ 2003-09-05 14:09:47.385839
0000 00 00 00 00 |....|


Sending packet @ 2003-09-05 14:09:47.385860
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|


Archive powered by MHonArc 2.6.24.

Top of Page