[freetds] [nativecode=00000 "ÂÁ@] error when doing query

Sims, Benjamin B.Sims at unesco.org
Fri Jun 23 08:37:55 EDT 2006


> DSN is used only during connection

Right, but I presume the type of connection (native windows versus freetds) makes a difference. As I said in my other message, it seems to be somewhere between PEAR and ODBC that problems are happening.

-----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 14:10
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?
> 

Yes, if connection close this can be the reason...

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

?? DSN is used only during connection...

> Ben
> 

freddy77


> -----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
> 
> 
_______________________________________________
FreeTDS mailing list
FreeTDS at lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds


More information about the FreeTDS mailing list