Skip to Content.
Sympa Menu

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

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Sims, Benjamin" <B.Sims AT unesco.org>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] [nativecode=00000 "ÂÁ@] error when doing query
  • Date: Fri, 23 Jun 2006 12:30:13 +0200

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




Archive powered by MHonArc 2.6.24.

Top of Page