Re: PostgresSQL 7.1 and ODBC/MSAccess

I am having a related problem with the 7.1 ODBC driver.

Records which I write using JDBC are fine which I use pgaccess to view them.
However, if I use ODBC and Access and do a link table, the data appears a
jiberish.

"Lieven Van Acker" <lieven(at)elisa(dot)be> wrote in message
news:3B095301(dot)81CA0F2A(at)elisa(dot)be(dot)(dot)(dot)
> Hey Scott,
>
> I remember I had to upgrade the PostgreSQL ODBC driver from 7.0 to 7.1
series. Then everything worked fine.
>
> Greetings,
>
> Lieven
>
> Scott Gilbert wrote:
>
> > I have a problem with PostgresSQL 7.1 and Micro$oft Windoze ODBC and MS
> > Access 2000 which I am hoping someone here might be able to help me
with.
> >
> > When I try to link MS Access to a PostgresSQL 7.1 table, Access is
unable to
> > see any of the tables in the database so I cannot select a table to
link.
> >
> > I have no problem with PostgresSQL 7.03 nor with MySQL. When I attempt
to
> > connect to the database using ZDE (a windows database client) I have no
> > problem; probably because ZDE does not use the windows DSN. At lease,
that
> > is what I am assuming.
> >
> > I have attempted this with two separate 7.1 databases on two separate
> > machines, one set up by me on a debian linux box the other set up by our
> > network administrator so I don't _think_ it's a setup issue with
PostgresSQL
> > 7.1
> >
> > Is there a URL for the latest driver for PostgresSQL 7.1 (I've
downloaded a
> > new driver but I'm not certain it's the most recent)?
> >
> > Is there some known issue with PostgresSQL 7.1 and windows ODBC (windows
NT
> > that is)?
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 4: Don't 'kill -9' the postmaster
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org