Re: Oracle Heterogenous Services Error

We are able to connect via sql server to postgres. Also, we are providing the username in lowercase, the Oracle error always returns it in uppercase.

----- Original Message -----

Subject: Re: [ODBC] Oracle Heterogenous Services Error

From: "Ludek Finstrle" >;luf(at)pzkagis(dot)cz>

Date: Wed, June 21, 2006 2:15

> 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

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster