freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
Re: [freetds] Getting stored procedure output parameters and returnvalues
- From: "ZIGLIO, Frediano, VF-IT" <Frediano.Ziglio AT vodafone.com>
- To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
- Subject: Re: [freetds] Getting stored procedure output parameters and returnvalues
- Date: Wed, 11 Apr 2007 16:10:59 +0200
>
> Hi good people, I'm new in this list and new too in unixODBC.
> I'm having a problem with output parameter and return
> values of SQLServer stored procedures.
>
> I'm using FreeTDS driver but unixODBC API. So, I believe to
> be doing everything in right way, but don't work.
>
> I created a SP with an output parameter. My code do:
>
> - SQLPrepare with statement "{ call sp_myproc (?) }"
> - SQLBindParameter with
> SQL_PARAM_OUTPUT
> - SQLExecute
>
> Do not occurs errors, but the parameter is not returned.
>
> This also occurs with return values of SPs with statement
> "{ call sp_myproc (?) }" and SQLBindParameter with
> SQL_PARAM_OUTPUT.
>
> Some help is welcome...
> Thaks
>
Hi,
this is not sufficient, you have to read all data
(SQLFetch/SQLMoreResults) returned by SQLExecute cause parameters are
the last thing server returns
Frediano Ziglio
-
[freetds] Getting stored procedure output parameters and return values,
João M L Amaral, 04/11/2007
-
Re: [freetds] Getting stored procedure output parameters and returnvalues,
ZIGLIO, Frediano, VF-IT, 04/11/2007
-
Re: [freetds] Getting stored procedure output parameters and returnvalues,
João M L Amaral, 04/11/2007
- Re: [freetds] Getting stored procedure output parameters and returnvalues, João M L Amaral, 04/11/2007
-
[freetds] another strange thing with sp's,
João M L Amaral, 04/11/2007
- Re: [freetds] another strange thing with sp's, ZIGLIO, Frediano, VF-IT, 04/12/2007
-
Re: [freetds] Getting stored procedure output parameters andreturnvalues,
ZIGLIO, Frediano, VF-IT, 04/12/2007
-
Re: [freetds] Getting stored procedure output parameters andreturnvalues,
João M L Amaral, 04/12/2007
-
Re: [freetds] Getting stored procedure output parametersandreturnvalues,
ZIGLIO, Frediano, VF-IT, 04/12/2007
-
Re: [freetds] Getting stored procedure output parametersandreturnvalues,
João M L Amaral, 04/12/2007
- Re: [freetds] Getting stored procedure output parametersandreturnvalues, João M L Amaral, 04/12/2007
- Re: [freetds] Getting stored procedure outputparametersandreturnvalues, ZIGLIO, Frediano, VF-IT, 04/12/2007
-
Re: [freetds] Getting stored procedure output parametersandreturnvalues,
João M L Amaral, 04/12/2007
-
Re: [freetds] Getting stored procedure output parametersandreturnvalues,
ZIGLIO, Frediano, VF-IT, 04/12/2007
-
Re: [freetds] Getting stored procedure output parameters andreturnvalues,
João M L Amaral, 04/12/2007
-
Re: [freetds] Getting stored procedure output parameters and returnvalues,
João M L Amaral, 04/11/2007
-
Re: [freetds] Getting stored procedure output parameters and returnvalues,
ZIGLIO, Frediano, VF-IT, 04/11/2007
Archive powered by MHonArc 2.6.24.