Skip to Content.
Sympa Menu

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

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: João M L Amaral <joaomarcelodf AT yahoo.com.br>
  • To: freetds AT lists.ibiblio.org
  • Subject: [freetds] En: Getting stored procedure output parameters and return values
  • Date: Wed, 11 Apr 2007 10:18:53 -0300 (ART)



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/



  • [freetds] En: Getting stored procedure output parameters and return values, João M L Amaral, 04/11/2007

Archive powered by MHonArc 2.6.24.

Top of Page