Skip site navigation (1) Skip section navigation (2)

connection weirdness from MS Access when using ident and password

From: "David M(dot) Kaplan" <dmkaplan(at)ucdavis(dot)edu>
To: pgsql-odbc(at)postgresql(dot)org
Subject: connection weirdness from MS Access when using ident and password
Date: 2002-06-18 03:37:31
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-odbc

I recently experienced a weird bug with the ODBC driver (or postgresql). 
 I am running:


I was trying to connect to a database using MS Access.  Initially, my 
pg_hba.conf looked like:

host       all    ident    sameuser
host    all    password

where my machine is and the MS client is 
 Connecting using ODBC failed with this configuration stating:

FATAL 1: IDENT authentification failed for user 'me' (#210)

Then I changed the order of the lines in my configuration file:

host    all    password
host       all    ident    sameuser

Now the ODBC connection worked with out problems.  In the first case, it 
seems to be trying to use IDENT authentification, even though that 
should only apply to localhost.

David K.

pgsql-odbc by date

Next:From: Dave PageDate: 2002-06-18 07:22:34
Subject: Re: ODBC questions
Previous:From: Timothy ReavesDate: 2002-06-17 23:53:20
Subject: ODBC questions

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group