Re: BUG #5547: not able to connect to postgres through the oracle using Linux ODBC driver for Postgres

"Hemanth" <hxkuma5(at)qwest(dot)com> writes:
> I am able to install Linux ODBC driver for Postgres successfully. i am able
> to connect to the postgres using demo in the driver.
> but not able to connect to the postgres using the same username and password
> from DB LINK created b/w postgres and oracle .

> ERROR at line 1:
> ORA-01017: invalid username/password; logon denied [DataDirect][ODBC
> PostgreSQL Wire Protocol driver][PostgreSQL]FATAL: role "AIP"
> does not exist(File miscinit.c;Line 382;Routine InitializeSessionUserId
> [DataDirect][ODBC PostgreSQL Wire Protocol driver]Socket closed.
> ORA-02063: preceding 2 lines from APPLES

Wow, there's a lot of extraneous crud in their error messages isn't
there? But I think the relevant bit is
FATAL: role "AIP" does not exist
Are you sure you created the user correctly? Note that Oracle seems to
be sending the role name in all upper case --- if you can't make it stop
doing that, you're going to have to create the user as "AIP" not "aip".
Those are different names.

regards, tom lane