Please keep replies on the list...
> -----Original Message-----
> From: babafemi.osoba@bt.com [mailto:babafemi.osoba@bt.com]
> Sent: 07 June 2002 15:23
> To: Dave Page
> Subject: RE: [ODBC] ODBC error - Password authentication
>
>
> These are the entries in my pg_hba.conf file.
>
> local all
> trust
> host all 127.0.0.1
> 255.255.255.255 md5
> host sameuser 132.146.232.115 255.255.255.255
> md5
>
> The ODBC driver is installed on machine 132.146.232.115.
> Interestingly, I can connect to the DB with psql on the local
> machine (127.0.0.1) using md5 without any problems. I have
> attached the conf file.
>
Are you sure your local psql connection isn't being allowed by the line:
local all trust
I have never tried using sameuser (I'm hacking code on my dev box and
can't try it right now) - can you try changing that to 'all'
temporarily, and testing again please?
Regards, Dave.