Re: ODBC error - Password authentication

Please keep replies on the list...

> -----Original Message-----
> From: babafemi(dot)osoba(at)bt(dot)com [mailto:babafemi(dot)osoba(at)bt(dot)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.