FreeTDS Development Group

[Frediano Ziglio <freddyz77 AT tin.it>]

Il ven, 2002-11-15 alle 19:44, Castellano, Nicholas ha scritto:
> Agreed that it's different...but experimentation shows we don't get anything
> at all that might provide information about the output parameters in a TDS7
> stream for this type of query.  The returned stream looks pretty much
> identical to what we get using TDS4.2, with the 0xAC token stream
> conspicuously missing.
> 
> If my statements on this subject are vague and imprecise, they probably are.
> I haven't been able to assimilate everything on this topic and it's not a
> real high priority for me.  My only interest in this matter is having the
> unit tests all pass so we don't get a billion questions about the failures
> after the next release.  So mostly I'm just resorting to hand-waving (or
> obscene gestures, take your pick).
> 
> That said, if we can find evidence that this really works in TDS7 streams
> with MS's libraries, I'm willing to put in some effort towards fixing it for
> real in our code base.
> 
> Cheers,
> --nick
> 

Nick you have to use dynamic query or RPC. If you exec statement like "EXEC 
sp_test 1, 2, 3" you do not receive output parameters.
Try to call an RPC on sp_test or exec a dynamic query and you'll see output 
parameters (in either TDS5 and TDS7)

freddy77