Can not get ODBC to log. Trace is not working.

[Roy Souther <roy@xxxxxxxxxxxxxx>]

I am trying to get the ODBC client to log but I just can't. I have included my odbc.ini and odbcinst.ini. Can anyone tell me why there is never a log file created? I connect to the database with isql and OpenOffice, run queries and get data but never do I ever get a log file.

Shouldn't it just log if I have 
Trace = Yes
TraceFile = /tmp/odbc.log
in my odbc.ini file?

What am I doing wrong? I had this working before on Mandrake. I am using Debian now. I need to find out why I cannot trace. I have a different system where the client is not working and I cannot get it to trace either. It is running an old version of Mandrake. I want to get my system actually tracing to a log file before I go and try to debug the other system.

Royce Souther
www.SiliconTao.com
Let Open Source help your business move beyond.

For security this message is digitally authenticated by GnuPG.

[Prover]
Description	= OpenOffice link to Prover
Driver		= PostgreSQL
Trace		= Yes
TraceFile	= /tmp/odbc.prover.log
Database	= mmplinked
Servername	= 192.168.0.250
Username	= proveruser
Password	= 
Port		= 5432
Protocol	= 6.4
ReadOnly	= No
RowVersioning	= No
ShowSystemTables= No
ShowOidColumn	= No
FakeOidIndex	= No
ConnSettings	= 

[PostgreSQL]
Description	= ODBC for PostgreSQL
Driver		= /usr/lib/odbc/psqlodbc.so
Setup		= /usr/lib/odbc/psqlodbc.so
FileUsage	= 1
Debug		= 1
CommLog		= 1

Attachment: signature.asc
Description: This is a digitally signed message part