Skip to Content.
Sympa Menu

freetds - Re: [freetds] freetds and sqlrelay do not return result from stored procedure

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "James K. Lowden" <jklowden AT schemamania.org>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] freetds and sqlrelay do not return result from stored procedure
  • Date: Thu, 25 Dec 2003 16:36:51 -0500

On Tue, 23 Dec 2003 08:19:48 +0100, robert <robert AT redcor.ch> wrote:
> Hi there
> I am using the following setup:
> SuSE 9.0 and United Linux 1
> MS SQL 2000
> freetds 0.61
> rudiments 0.26.2
> sqlrelay 0.34.2
>
> I have the following problem:
> when I connect to SQLServer using any of the tds versions 4.2,7.0,8.0
> (5.0 fails to connect) I can execute select statements and they work
> fine. However a stored procedure that does return a selection set fails.
> sqlrsh reports: rows returned 0.
>
> If I execute the same statement from tsql I get the desired result. So
> the communication between tsql and sqlrelay seems not to work.

Does sqlrelay use the ct-lib interface?

0.61 has some problems with empty rowsets. Try a recent snapshot, please.
If that doesn't solve the problem, post a TDSDUMP log of the session.

--jkl




Archive powered by MHonArc 2.6.24.

Top of Page