Received: from u1.abs.net (root@u1.abs.net [207.114.0.131]) by hub.org (8.8.8/8.7.5) with ESMTP id OAA20381 for ; Mon, 6 Jul 1998 14:48:37 -0400 (EDT) Received: from insightdist.com (nobody@localhost) by u1.abs.net (8.9.0/8.9.0) with UUCP id OAA13820 for pgsql-interfaces@postgreSQL.org; Mon, 6 Jul 1998 14:28:11 -0400 (EDT) X-Authentication-Warning: u1.abs.net: nobody set sender to insightdist.com!daveh using -f Received: from ceodev by insightdist.com (AIX 3.2/UCB 5.64/4.03) id AA17258; Mon, 6 Jul 1998 12:32:05 -0400 Received: from daveh by ceodev (AIX 4.1/UCB 5.64/4.03) id AA74406; Mon, 6 Jul 1998 12:32:04 -0400 Message-Id: <35A0FD38.2AC5B5FE@insightdist.com> Date: Mon, 06 Jul 1998 12:37:14 -0400 From: David Hartwig Organization: Insight Distribution Systems X-Mailer: Mozilla 4.05 [en] (Win95; I) Mime-Version: 1.0 To: guy.corbaz@swissmail.com Cc: pgsql-interfaces Subject: Re: [INTERFACES] ODBC connection refused References: <359CC527.8F8A158@urbanet.ch> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit 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