Re: Oracle Heterogenous Services Error

Wed, Jun 21, 2006 at 11:29:28AM -0500, LLC napsal(a):
> 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.

Could you get the exact connection string?
Could you post here the mylog output?

Regards,

Luf

> ----- Original Message -----
>
>
> Subject: Re: [ODBC] Oracle Heterogenous Services Error
>
>
> From: "Ludek Finstrle" >;luf@pzkagis.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