Re: ODBC error - Password authentication

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.