From: | Alan Graham <alan(dot)graham(at)infonetsystems(dot)com(dot)au> |
---|---|
To: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Access97 to pgSQL, error Bad boolean external representation |
Date: | 2003-06-28 00:05:18 |
Message-ID: | 1056758718.2483.21.camel@bart.graham.fdns.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
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>
From | Date | Subject | |
---|---|---|---|
Next Message | A Mohan | 2003-06-28 10:53:45 | Create lo Data type |
Previous Message | Jeff Eckermann | 2003-06-27 18:27:45 | Re: Hi! |