Re: Oracle Heterogenous Services Error

[Ludek Finstrle <luf(at)pzkagis(dot)cz>]

> 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