[prev in list] [next in list] [prev in thread] [next in thread] 

List:       freetds
Subject:    Re: [freetds] FreeTDS Digest, Vol 134, Issue 5
From:       Frediano Ziglio <freddy77 () gmail ! com>
Date:       2014-03-29 19:04:21
Message-ID: CAHt6W4devamXg1PkwaWpPxiD0LZKKomiRivQBEc3xd_U0H5sHA () mail ! gmail ! com
[Download RAW message or body]

You have to use call syntax, see funccall test for instance. Mainly
you have to prepare (SQLPrepare) a query like "{call sp_name(?,?)}",
bind the parameters (2 in this example) and execute the query.

Frediano

2014-03-29 18:12 GMT+00:00  <sales@minixel.com>:
> 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@lists.ibiblio.org
> Date: 3/29/14 12:00 pm
> To: freetds@lists.ibiblio.org
>
> Send FreeTDS mailing list submissions to
>  freetds@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@lists.ibiblio.org
>
>  You can reach the person managing the list at
>  freetds-owner@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@freetds.org>
>  To: freetds@lists.ibiblio.org
>  Subject: Re: [freetds] dblib and output parameters of stored
>  procedures
>  Message-ID: <20140328192829.210db591.jklowden@freetds.org>
>  Content-Type: text/plain; charset=US-ASCII
>
>  On Thu, 27 Mar 2014 13:09:15 +0100
>  LacaK <lacak@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@lists.ibiblio.org
>  http://lists.ibiblio.org/mailman/listinfo/freetds
>
>
>  End of FreeTDS Digest, Vol 134, Issue 5
>  ***************************************
> _______________________________________________
> FreeTDS mailing list
> FreeTDS@lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
_______________________________________________
FreeTDS mailing list
FreeTDS@lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds
[prev in list] [next in list] [prev in thread] [next in thread]