PostgresSQL 7.1 and ODBC/MSAccess - Mailing list pgsql-general

From Scott Gilbert
Subject PostgresSQL 7.1 and ODBC/MSAccess
Date
Msg-id 000701c0e1d2$fe51cf50$8a01010a@nro.au.com
Whole thread Raw
In response to Re: Re: Which Front End for Postgresql  (Tony Grant <tony@animaproductions.com>)
List pgsql-general
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)?


pgsql-general by date:

Previous
From: Tony Grant
Date:
Subject: Re: Re: Which Front End for Postgresql
Next
From: Andrew Rawnsley
Date:
Subject: Queries across multiple databases  (was: SELECTfrom a table in another database).