[freetds] odbc trace file not there!
Frediano Ziglio
freddyz77 at tin.it
Fri Oct 15 01:28:31 EDT 2004
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
More information about the FreeTDS
mailing list