Re: dblib and output parameters of stored procedures

On Thu, 27 Mar 2014 13:09:15 +0100
LacaK <[email protected]> wrote:

> I am trying work with output parameters of stored procedures using 
> FreeTDS dblib
> I am calling stored procedure using:
>   "declare @p int; EXEC pokus 1, @p OUTPUT"
> after that call I am trying read count of output parametres using:
>   dbnumrets()
> but it still returns 0
> (same example tested with Microsoft ntwdblib returns 1)

Check the FAQ; you need to use the rpc functions to get the server to
return output parameters.  

ntwdblib uses TDS 4.2.  I guess the server still answers the old way on
the old protocol.  

HTH.  

--jkl