From: | "LLC" <kevin(at)kevinkempterllc(dot)com> |
---|---|
To: | "Ludek Finstrle" <luf(at)pzkagis(dot)cz> |
Cc: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: Oracle Heterogenous Services Error |
Date: | 2006-06-21 16:29:28 |
Message-ID: | 1150907368.v2.fusewebmail-164106@f |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Ludek Finstrle | 2006-06-21 16:45:57 | Re: Oracle Heterogenous Services Error |
Previous Message | Ludek Finstrle | 2006-06-21 08:15:30 | Re: Oracle Heterogenous Services Error |