Skip to Content.
Sympa Menu

freetds - Re: [freetds] Not getting return value and output parameter from storedprocedure.

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "ZIGLIO, Frediano, VF-IT" <Frediano.Ziglio AT vodafone.com>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Not getting return value and output parameter from storedprocedure.
  • Date: Fri, 5 Oct 2007 16:49:01 +0200


>
> Hi,
>
> We are using FreeTDS 0.65 (TDS version 8.0) and unixODBC
> 2.2.12 on RH Linux 3.4.6. We are connecting to Microsoft SQL
> Server 2000 from Linux. I am using C++ on Linux.
>

Is ebay selling time machine ??
I didn't note we release 0.65 :)
Don't mind, just kidding... I think you are using a snapshot which
report 0.65.

>
>
> Requirement: To get return value and output parameter after
> calling a stored procedure.
>
>
>
> We are calling Stored Procedure (SP) with input and output
> parameter and we are also expecting return value as well.
>
>
>
> We are calling stored procedure as follows:
>
>
>
> {? = CALL stp_returnRow(?, ?, ?)}
>
>

MMmm... a unixODBC trace would help. We support this type of call so it
should works... what's the problem?? Aren't datas readed correct? Does
execute report an error/warning??

>
> In above case we are expecting both return value and output
> parameter. The first parameter is input and 2nd and 3rd
> parameter is output parameter.
>
>

Remember that ODBC count also the result so you have 4 parameters.

>
> We have written the above query to unixODBC and we were
> informed that this problem is not in there Perview. This is
> for your information.
>
>
>
> Please suggest or give us solution if possible.
>
>
>
> Thanks & best regards,
>
> Rajesh Akolu
>

bye
freddy77




Archive powered by MHonArc 2.6.24.

Top of Page