FreeTDS Development Group

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

Follow up to this: I have just tested using the php odbc_connect function 
rather than the PEAR DB library, and the query goes through at this point 
fine! Weird...

I'll settle for this solution, but if anyone would be interested in helping 
further to track down the problem I would be happy to.

Ben

-----Original Message-----
From: freetds-bounces AT lists.ibiblio.org 
[mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of Sims, Benjamin
Sent: 23 June 2006 12:30
To: FreeTDS Development Group
Subject: Re: [freetds][nativecode=00000 "ÂÁ@
] error when doing query

Thanks,

>From what I understand from these logs, the query in question is never being 
>sent (please let me know if/where I should send them). I tend to think that 
>the connection is perhaps being closed - could this cause the error message?

This code works from a Windows box using a system DSN odbc connection, so I 
presume the connections must be behaving differently.

Ben

-----Original Message-----
From: freetds-bounces AT lists.ibiblio.org 
[mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of ZIGLIO, Frediano, 
VF-IT
Sent: 23 June 2006 11:46
To: FreeTDS Development Group
Subject: Re: [freetds][nativecode=00000 "ÂÁ@
] error when doing query

> 
> 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
> 

You have to launch isql/php from same session where you issue the commands.
Or using php you could include environment setting using php like

<?php
putenv("TDSDUMP=/tmp/freetds.log");
?> 

(remember to remove it in production environments :) )

freddy77

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