RE: [INTERFACES] Yet Another ODBC problem...

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(at)lacasabonita(dot)com]
Sent: Saturday, February 20, 1999 2:15 PM
To: pgsql-interfaces(at)postgreSQL(dot)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