[freetds] Not getting return value and output parameter fromstoredprocedure.
Rajesh Akolu
rajesh.akolu at ftindia.com
Mon Oct 8 10:08:00 EDT 2007
Hi,
In continuation with last conversation:
Find attached for your reference:
1. Trace file (strace.txt)
2. Code which we are testing (code.cpp)
3. Stored procedure (SP_TestParm.txt)
We are not getting any error.
We have set TDS Version = 8.0 and 7.0 in freeTDS.conf
Thanks & best regards,
Rajesh Akolu
Project Manager
Financial Technologies (India) Ltd.
Board No: 022-26831022 Extn: 254
Fax: 022-26836999
rajesh.akolu at ftindia.com
www.ftindia.com
Disclaimer:
The information in this E-mail (which includes any files transmitted
with it) is CONFIDENTIAL and may be legally PRIVILEGED. It is intended
solely for the addressee and access to this email by anyone else is
unauthorized. If you have received it in error, please destroy any
copies of this message, including any attachments, and delete it from
your system notifying the sender immediately. Any disclosure, copying,
distribution, dissemination, forwarding, printing or any action taken or
omitted to be taken in reliance on it or utilising the same for any
purpose other than what it is intended for, is prohibited and may be
unlawful.
-----Original Message-----
From: freetds-bounces at lists.ibiblio.org
[mailto:freetds-bounces at lists.ibiblio.org] On Behalf Of ZIGLIO,
Frediano, VF-IT
Sent: Friday, October 05, 2007 8:19 PM
To: FreeTDS Development Group
Subject: Re: [freetds] Not getting return value and output parameter
fromstoredprocedure.
>
> 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
_______________________________________________
FreeTDS mailing list
FreeTDS at lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: strace.txt
Url: http://lists.ibiblio.org/pipermail/freetds/attachments/20071008/b92d193b/attachment-0002.txt
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Code.cpp
Type: application/octet-stream
Size: 2047 bytes
Desc: not available
Url : http://lists.ibiblio.org/pipermail/freetds/attachments/20071008/b92d193b/attachment-0001.obj
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: SP_TestParm.txt
Url: http://lists.ibiblio.org/pipermail/freetds/attachments/20071008/b92d193b/attachment-0003.txt
More information about the FreeTDS
mailing list