Skip to Content.
Sympa Menu

freetds - Re: [freetds] odbc trace file not there!

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Frediano Ziglio <freddyz77 AT tin.it>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] odbc trace file not there!
  • Date: Fri, 15 Oct 2004 07:28:31 +0200

Il ven, 2004-10-15 alle 05:01, James K. Lowden ha scritto:
> Nilesh Dhawale <ndhawale AT gmail.com> wrote:
> > > http://www.freetds.org/userguide/odbcconnattr.htm
> > > That's our comprehensive list. Note the final column, "In odbc.ini".
> > > A"yes" means the attribute may be used in odbc.ini; "no" implies it's
> > > used only in connection strings.
> >
> > oh, I had seen that list but did not realize that it is an exhaustive
> > list. But then what about TRACE? Could that be the reason why I am not
> > getting a trace file enev when I use TRACE and TRACEFILE? Is tracing
> > _not_ supported by freeTDS at all or it has to in hte odbcinst.ini
> > file rather than the odbc.ini file?
>
> TRACE is not a FreeTDS ODBC driver attribute. It belongs to the Driver
> Manager unixODBC. Other DMs might or might not support it.
>
> FWIW, the one time I tried to use TRACE, I failed, too. I might not have
> had sufficient rights on that particular box, or maybe there was some
> other magic I didn't know about....
>

Confirm. trace it's a DM stuff, in my odbcinst.ini I have

[ODBC]
Trace = Yes
TraceFile = /tmp/sql.log
ForceTrace = Yes

It's a global flag so don't use it in a production environment (or don't
forget to remove ASAP).

freddy77






Archive powered by MHonArc 2.6.24.

Top of Page