Skip to Content.
Sympa Menu

freetds - RE: Output parameters (src/dblib/unittests/t0022.c)

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Frediano Ziglio <freddyz77 AT tin.it>
  • To: TDS Development Group <freetds AT franklin.oit.unc.edu>
  • Subject: RE: Output parameters (src/dblib/unittests/t0022.c)
  • Date: 09 Oct 2002 12:56:35 +0200


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






Archive powered by MHonArc 2.6.24.

Top of Page