FreeTDS Development Group

["Sims, Benjamin" <B.Sims AT unesco.org>]

I am wondering if it might be related to multiple connections being 
open/persistent connections/multiple result sets. The code is doing something 
like this:

1. Return various rows
2. Iterate over them
3. If a certain field is not null, call a function which runs another select 
to get a value based on that field
4. Add the value to that particular row

(I'm aware that I could do this with a left join)

How can I enable TDSDUMP? I've read 
http://www.freetds.org/userguide/logging.htm

And done
export TDSDUMP="/tmp/freetds.log"
export TDSDUMPCONFIG=""

However, I'm seeing nothing in the /tmp/freetds.log file, whether I run 
queries through isql or PHP.

Ben


-----Original Message-----
From: freetds-bounces AT lists.ibiblio.org 
[mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of Frediano Ziglio
Sent: 22 June 2006 21:28
To: FreeTDS Development Group
Subject: Re: [freetds][nativecode=00000 "ÂÁ@
] error when doing query

Il giorno gio, 22/06/2006 alle 17.42 +0200, Sims, Benjamin ha scritto:
> Hi,
> 
> 
> I have an application written in PHP, which uses unixODBC and FreeTDS to 
> connect to a MSSQL server. For some reason, when I run a particular query 
> (a very simple select on a single table) as part of an object which makes a 
> lot of other queries the database throws the following error:
> 
>  
> 
> [nativecode=00000 "ÂÁ@]
> 
>  
> 
> In every other circumstance (the function used on its own, isql, etc) the 
> query appears to work perfectly normally. 
> 
>  
> 
> Would anybody have any ideas as to where I should start looking for the 
> source of this? I realize it may not even be FreeTDS, but this list was the 
> only one on which I could find even slightly similar errors discussed.
> 
>  

Probably you are in the right place... this should be cause by our ODBC
that return SQL_ERROR without setting an error. This should cause the
garbage print you have. Is difficult however to understand the error...
one option is that server close connection. If you are able to reproduce
the error a TDSDUMP would be helpful.

freddy77


_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds