> I've setup a user 'pgadmin' for testing. I've added an entry in the
> pg_hba.conf file as follows:
Here is username lowercase.
> When we try and connect we get this error:
>
> (0) ORACLE GENERIC GATEWAY Log File Started at 2006-06-20T15:05:18
> (0) hoainit (3): ; hoainit Exited with retcode = 0.
> (0) hoalgon (7): ; hoalgon Entered. name = PGADMIN.
> (0) DB_ODBC_INTERFACE (2085): ; FATAL: password authentication failed
> for user
> (0) "PGADMIN" (SQL State: 28000; SQL Code: 210
Here is username uppercase. I think postgresql is case-sensitive.
Could you connect via odbc the postgresql from another app?
Regards,
Luf