Skip to Content.
Sympa Menu

freetds - Re: [freetds] dblib and output parameters of stored procedures

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "James K. Lowden" <jklowden AT freetds.org>
  • To: freetds AT lists.ibiblio.org
  • Subject: Re: [freetds] dblib and output parameters of stored procedures
  • Date: Fri, 28 Mar 2014 19:28:29 -0400

On Thu, 27 Mar 2014 13:09:15 +0100
LacaK <lacak AT zoznam.sk> 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






Archive powered by MHonArc 2.6.24.

Top of Page