freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
- From: sales AT minixel.com
- To: freetds AT lists.ibiblio.org
- Subject: Re: [freetds] FreeTDS Digest, Vol 134, Issue 5
- Date: Sat, 29 Mar 2014 11:12:51 -0700
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: freetds-request AT lists.ibiblio.org
Date: 3/29/14 12:00 pm
To: freetds AT lists.ibiblio.org
Send FreeTDS mailing list submissions to
freetds AT lists.ibiblio.org
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
freetds-request AT lists.ibiblio.org
You can reach the person managing the list at
freetds-owner AT lists.ibiblio.org
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" <jklowden AT freetds.org>
To: freetds AT lists.ibiblio.org
Subject: Re: [freetds] dblib and output parameters of stored
procedures
Message-ID: <20140328192829.210db591.jklowden AT freetds.org>
Content-Type: text/plain; charset=US-ASCII
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
------------------------------
_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds
End of FreeTDS Digest, Vol 134, Issue 5
***************************************
-
Re: [freetds] FreeTDS Digest, Vol 134, Issue 5,
sales, 03/29/2014
- Re: [freetds] FreeTDS Digest, Vol 134, Issue 5, Frediano Ziglio, 03/29/2014
Archive powered by MHonArc 2.6.24.