I am doing the same thing right now. I found that teaking the data types of
the tables in Postgres helps. For example:
Access data type Postgres data type
Boolean int2
>char(20) varchar
<=char(20) char
The use of varchar over char seem to help the most with errors, especially
with long character fields.
Thanks, Michael
-----Original Message-----
From: J. J. Franzen [SMTP:jj@lacasabonita.com]
Sent: Saturday, February 20, 1999 2:15 PM
To: pgsql-interfaces@postgreSQL.org
Subject: [INTERFACES] Yet Another ODBC problem...
I've been hunting through the archives of this list for answers to a
specific
problem... I'm trying to link tables from Access 97 to Postgres
6.4.2 and
getting a ODBC call failed error whenever I try to view the table.
Now, I've
found messages discussing the problem, but I can't find any
suggestions on how
to fix, or at least work around, the problem. Any suggestions would
be
greatly
appreciated. Thanks,
J. J. Franzen