pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  
help / color / mirror / Atom feed
ODBC connection refused
2+ messages / 2 participants
[nested] [flat]

* ODBC connection refused
@ 1998-07-03 11:48  Guy Corbaz <guy.corbaz@urbanet.ch>
  0 siblings, 1 reply; 2+ messages in thread

From: Guy Corbaz @ 1998-07-03 11:48 UTC (permalink / raw)
  To: pgsql-interfaces

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








^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: [INTERFACES] ODBC connection refused
@ 1998-07-06 16:37  David Hartwig <daveh@insightdist.com>
  parent: Guy Corbaz <guy.corbaz@urbanet.ch>
  0 siblings, 0 replies; 2+ messages in thread

From: David Hartwig @ 1998-07-06 16:37 UTC (permalink / raw)
  To: guy.corbaz@swissmail.com; +Cc: pgsql-interfaces

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






^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~1998-07-06 16:37 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1998-07-03 11:48 ODBC connection refused Guy Corbaz <guy.corbaz@urbanet.ch>
1998-07-06 16:37 ` David Hartwig <daveh@insightdist.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox