I realize that this is easier said than done, but you may want to get your
PostgreSQL server and ODBC driver. I am not aware of any active support for
these earlier releases of the driver. (v0.31 or earlier)
The latest driver can be found at http://www.insightdist.com/psqlodbc. We
will do our best to support you in your use of this driver. Unfortunately,
this driver only works with ProstgreSQL 6.2+.
Guy Corbaz wrote:
> Hello,
>
> I'm trying to use ODBC to mount a Postgres table in MS Access. I'm using
>
> posodbc 0.31.0000, with postgresql 6.1. My pg_hba.conf file contains the
>
> following lines
>
> host all 127.0.0.1 255.255.255.255 trust
> host all 0.0.0.0 0.0.0.0 trust
>
> and I received the following message (from the postmaster)
>
> be_recvauth: host-based authentication failed
> /usr/bin/postmaster: ConnStartup: Failed to authenticate client as
> Postgres user 'gcorbaz' using the default authentication type: bd
>
> However, I can use psql on the server, using the gcorbaz account.
>
> Does anyone have an idea ?
>
> Thank you