[freetds] Getting stored procedure output parameters and returnvalues

ZIGLIO, Frediano, VF-IT Frediano.Ziglio at vodafone.com
Wed Apr 11 10:10:59 EDT 2007


> 
> 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



More information about the FreeTDS mailing list