freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

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

From: robert <robert AT redcor.ch>
To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
Subject: Re: [freetds] freetds and sqlrelay do not return result from stored procedure
Date: Tue, 23 Dec 2003 09:25:36 +0100

here is some more information:
when I turn on debugging, I get the following output :
2/23/2003 09:18:19 CET connection [4575] : spr_fha_personensucheIntranet
'Fuchs','','','',-1,-1

12/23/2003 09:18:19 CET connection [4575] : getting query
succeeded

12/23/2003 09:18:19 CET connection [4575] : getting input binds...

12/23/2003 09:18:19 CET connection [4575] : done getting input
binds

12/23/2003 09:18:19 CET connection [4575] : getting output
binds...

12/23/2003 09:18:19 CET connection [4575] : done getting output
binds

12/23/2003 09:18:19 CET connection [4575] : getting send column
info...

12/23/2003 09:18:19 CET connection [4575] : send column
info

12/23/2003 09:18:19 CET connection [4575] : done getting send
column info...

12/23/2003 09:18:19 CET connection [4575] : processing query...

12/23/2003 09:18:19 CET connection [4575] : preparing/
executing...

12/23/2003 09:18:19 CET connection [4575] : commit or rollback
check...

12/23/2003 09:18:19 CET connection [4575] : commit or
rollback needed

12/23/2003 09:18:19 CET connection [4575] : done with commit or
rollback check

12/23/2003 09:18:19 CET connection [4575] : processing query
succeeded

12/23/2003 09:18:19 CET connection [4575] : done processing query

12/23/2003 09:18:19 CET connection [4575] : returning result set
header...

12/23/2003 09:18:19 CET connection [4575] : returning row
counts...

12/23/2003 09:18:19 CET connection [4575] : sending row counts...

12/23/2003 09:18:19 CET connection [4575] : actual rows
unknown

12/23/2003 09:18:19 CET connection [4575] : affected
rows:
0

12/23/2003 09:18:19 CET connection [4575] : done sending row
counts

12/23/2003 09:18:19 CET connection [4575] : done
returning
row counts

12/23/2003 09:18:19 CET connection [4575] : column info
will be sent

12/23/2003 09:18:19 CET connection [4575] : returning
column counts...

12/23/2003 09:18:19 CET connection [4575] : sending column count..
12/23/2003 09:18:19 CET connection [4575] : 0

12/23/2003 09:18:19 CET connection [4575] : done sending column
count

12/23/2003 09:18:19 CET connection [4575] : done
returning
column counts

12/23/2003 09:18:19 CET connection [4575] : returning
column info...

12/23/2003 09:18:19 CET connection [4575] : sending column type
format...

12/23/2003 09:18:19 CET connection [4575] : id's

12/23/2003 09:18:19 CET connection [4575] : done sending column
type format

12/23/2003 09:18:19 CET connection [4575] : done
returning
column info

12/23/2003 09:18:19 CET connection [4575] : returning output bind
values

12/23/2003 09:18:19 CET connection [4575] : 0

12/23/2003 09:18:19 CET connection [4575] : done returning output
bind values

12/23/2003 09:18:19 CET connection [4575] : done returning result
set header

12/23/2003 09:18:19 CET connection [4575] : handle query succeeded

12/23/2003 09:18:19 CET connection [4575] : returning result set
data...

12/23/2003 09:18:19 CET connection [4575] : done returning result
set data

12/23/2003 09:18:19 CET connection [4575] : getting command...

On Tuesday 23 December 2003 08:19, robert 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.
>
> How can I rectify this.
> Thanks for your help
>
> Robert
>
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds

[freetds] freetds and sqlrelay do not return result from stored procedure, robert, 12/23/2003
- Re: [freetds] freetds and sqlrelay do not return result from stored procedure, robert, 12/23/2003
- Re: [freetds] freetds and sqlrelay do not return result from stored procedure, James K. Lowden, 12/25/2003