Access97 to pgSQL, error Bad boolean external representation

Apologies if this is a well known problem, I have googled extensively
for the error message and can find what I doing wrong.

I am in the process of converting an Access 97 app to use PostgreSQL as
the backend. For the moment I´m keeping Access as the frontend.

PostgreSQL is version 7.2.1 running on Debian Woody

ODBC Driver is version 7.03.01, on windows 98. Downloaded and installed
last week.

I finished the conversion successfully, I think, but I´m having problems
with boolean data types when the app is running. I´ve set up a test
table, containing only a key, a boolean field and a currency field.
Saving a record from Access with a false value in the boolean works ok,
but saving a true value fails with an ODBC error. The error message
from the ODBC log is:

SC_get_error: status = 7, msg = #ERROR: Bad boolean external
representation '-1'#

I´ve tried to change the settings in the ODBC config. The two settings
I´ve been changing are
Bool as Char, and
True is -1 (on page 2 of the config screen)

I´ve tried all 4 combinations of these settings, both with the
PostgreSQL driver and with the PostgreSQL Legacy driver. Nothing I´ve
changed has had an effect, ie, I get the same message in all 8 cases. I
exit out off Access completely between tests.

As I´m getting the same error no matter the setting, I´m tempted to
believe that I´m changing the wrong DSN, or that there´s some trick to
saving the settings so that they´re actioned? I´ve checked the DSN in
the log each time, so... What stupid newbie error am I making?

Thanks for your help

Alan Graham

--
Alan Graham <alan(dot)graham(at)infonetsystems(dot)com(dot)au>