[freetds] En: Getting stored procedure output parameters and return values

João M L Amaral joaomarcelodf at yahoo.com.br
Wed Apr 11 09:18:53 EDT 2007



João M L Amaral <joaomarcelodf at yahoo.com.br> escreveu:  Data: Wed, 11 Apr 2007 10:16:11 -0300 (ART)
De: João M L Amaral <joaomarcelodf at yahoo.com.br>
Assunto: Getting stored procedure output parameters and return values
Para: freetds at lists.ibiblio.org

  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
   
   
   


Atenciosamente,
João M L Amaral  __________________________________________________
Fale com seus amigos de graça com o novo Yahoo! Messenger 
http://br.messenger.yahoo.com/ 



Atenciosamente,
João M L Amaral
 __________________________________________________
Fale com seus amigos  de graça com o novo Yahoo! Messenger 
http://br.messenger.yahoo.com/ 


More information about the FreeTDS mailing list