[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