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@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