FreeTDS Development Group

[Frediano Ziglio <freddyz77 AT tin.it>]

Il mer, 2002-10-09 alle 06:35, Thompson, Bill D (London) ha scritto:
> Nick,
> 
> I knew this rung a bell somewhere, and I just checked it.
> It's not true to say that TDS 7/8 never sends an 0xAC token - it does.
> I've just executed dblib/unittests/t0014 against a SQL 2000 database using
> TDS 7
> and that gets back a 0xac token - although freetds 0.60 doesn't recognise
> it!
> 

It work for me. I tested t0022 with tds7, below result:

[freddy@freddy unittests]$ ./t0022  
Start
About to logon
About to open
Dropping proc
Msg 3701, Level 11, State 5
Server 'ONEIRIDE', Line 1
Cannot drop the procedure 't0022', because it does not exist in the
system catalog.
creating proc
declare @b int
exec t0022 @b = @b output

ret name 1 is @b
ret type 1 is 56
ret len 1 is 4
ret data 1 is 42
Dropping proc
dblib okay on t0022.c

The dump

000000FE  01 01 00 80 00 00 01 00  63 00 72 00 65 00 61 00 ........
c.r.e.a.
0000010E  74 00 65 00 20 00 70 00  72 00 6f 00 63 00 20 00 t.e. .p.
r.o.c. .
0000011E  74 00 30 00 30 00 32 00  32 00 20 00 28 00 40 00 t.0.0.2. 2.
.(.@.
0000012E  62 00 20 00 69 00 6e 00  74 00 20 00 6f 00 75 00 b. .i.n. t.
.o.u.
0000013E  74 00 29 00 20 00 61 00  73 00 0a 00 62 00 65 00 t.). .a.
s...b.e.
0000014E  67 00 69 00 6e 00 0a 00  20 00 73 00 65 00 6c 00 g.i.n... 
.s.e.l.
0000015E  65 00 63 00 74 00 20 00  40 00 62 00 20 00 3d 00 e.c.t. . @.b.
.=.
0000016E  20 00 34 00 32 00 0a 00  65 00 6e 00 64 00 0a 00  .4.2...
e.n.d...
                                                                              
0000030E  04 01 00 11 00 00 00 00  fd 00 00 de 00 00 00 00 ........ ý..Þ....
                                                                              
0000031E  00                                               .
0000017E  01 01 00 5a 00 00 01 00  64 00 65 00 63 00 6c 00 ...Z....
d.e.c.l.
0000018E  61 00 72 00 65 00 20 00  40 00 62 00 20 00 69 00 a.r.e. . @.b.
.i.
0000019E  6e 00 74 00 0a 00 65 00  78 00 65 00 63 00 20 00 n.t...e.
x.e.c. .
000001AE  74 00 30 00 30 00 32 00  32 00 20 00 40 00 62 00 t.0.0.2. 2.
.@.b.
000001BE  20 00 3d 00 20 00 40 00  62 00 20 00 6f 00 75 00  .=. .@. b.
.o.u.
000001CE  74 00 70 00 75 00 74 00  0a 00                   t.p.u.t. ..


                                                                              
0000031F  04 01 00 33 00 00 00 00  ff 11 00 c1 00 01 00 00 ...3.... ÿ..Á....
                                                                              
0000032F  00 79 00 00 00 00 ac 11  00 02 40 00 62 00 01 00 .y....¬. ..@.b...
                                                                              
0000033F  00 00 00 26 04 04 2a 00  00 00 fe 00 00 e0 00 01 ...&..*. ..þ..à..

^^^ result ^^^
                                                                              
0000034F  00 00 00                                         ...
000001D8  01 01 00 26 00 00 01 00  64 00 72 00 6f 00 70 00 ...&....
d.r.o.p.
000001E8  20 00 70 00 72 00 6f 00  63 00 20 00 74 00 30 00  .p.r.o. c.
.t.0.
000001F8  30 00 32 00 32 00                                0.2.2.
                                                                              
00000352  04 01 00 11 00 00 00 00  fd 00 00 df 00 00 00 00 ........ ý..ß....
                                                                              
00000362  00                                               .

freddy77