Re: FreeTDS Digest, Vol 134, Issue 5

I noticed that the only way to pass and receive parameters is using TDS 4.1.
How do we do this using newer TDS versions? I have failed to do that.
I use unixODBC with FreeTDS underneath.
 
 
--------- Original Message --------- Subject: FreeTDS Digest, Vol 134, Issue 5
From: [email protected]
Date: 3/29/14 12:00 pm
To: [email protected]

Send FreeTDS mailing list submissions to
 [email protected]
 
 To subscribe or unsubscribe via the World Wide Web, visit
 http://lists.ibiblio.org/mailman/listinfo/freetds
 or, via email, send a message with subject or body 'help' to
 [email protected]
 
 You can reach the person managing the list at
 [email protected]
 
 When replying, please edit your Subject line so it is more specific
 than "Re: Contents of FreeTDS digest..."
 
 
 Today's Topics:
 
 1. Re: dblib and output parameters of stored procedures
 (James K. Lowden)
 
 
 ----------------------------------------------------------------------
 
 Message: 1
 Date: Fri, 28 Mar 2014 19:28:29 -0400
 From: "James K. Lowden" <[email protected]>
 To: [email protected]
 Subject: Re: [freetds] dblib and output parameters of stored
 procedures
 Message-ID: <[email protected]>
 Content-Type: text/plain; charset=US-ASCII
 
 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
 
 
 
 
 ------------------------------
 
 _______________________________________________
 FreeTDS mailing list
 [email protected]
 http://lists.ibiblio.org/mailman/listinfo/freetds
 
 
 End of FreeTDS Digest, Vol 134, Issue 5
 ***************************************