freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

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

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