Skip to Content.
Sympa Menu

freetds - RE: [freetds] Stored Procedure Output Parameters Not Being Returned

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "ZIGLIO Frediano" <Frediano.Ziglio AT vodafoneomnitel.it>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] Stored Procedure Output Parameters Not Being Returned
  • Date: Fri, 9 May 2003 18:00:55 +0200

>
> I have read the various threads on this topic but am left with some
> questions.
>
> I am using SQL Server 7.0 SP3. I have tried freeTDS 0.60,
> 0.61 and last
> nights snapshot on a RedHat9 i686 system and unixODBC. The
> threads suggest
> that Microsoft made a change in 7.0 SP3 that broke stored
> proceedure output
> params in freeTDS, but what is not clear is what needs to be
> done to fix it
> and if anything is being done about it.
>
> We absolutely need this to work. If it should work with the
> code I have,
> what am I likely to be doing wrong? If it is broken, is
> anyone looking to
> fix it in the near term? If not I will attempt to fix it. I
> have looked at
> the TDS packets on the network and can only see the Return
> Status (0x79)
> coming back, no sign of the output parameters.
>
> If I attempt to fix this, what info is available on the TDS
> protocol beyond
> what is in tds.html?
>
> Thanks,
>
> Tim Court
> Consulting Engineer
> Concurrent Computer Corporation
> Xstreme Division
>

Hi Tim!

This is one of my TODO for 0.62. Not still in CVS.
RPC output will work with syntax like " { ?


= call
myproc(?,?,?)
} "
(this is a syntax that work even with ms...).

However syntax like "{?=call myproc(??)} select * from table" (with more
statement) won't work...

freddy77




Archive powered by MHonArc 2.6.24.

Top of Page