Обсуждение: BUG #5546: not able to connect to postgres through the oracle using

The following bug has been logged online:

Bug reference:      5546
Logged by:          Hemanth
Email address:      hxkuma5@qwest.com
PostgreSQL version: 8.4
Operating system:   Linux
Description:        not able to connect to postgres through the oracle using
Details:

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

On 8/07/2010 10:33 PM, Hemanth wrote:
>
> The following bug has been logged online:
>
> Bug reference:      5546
> Logged by:          Hemanth
> Email address:      hxkuma5@qwest.com
> PostgreSQL version: 8.4
> Operating system:   Linux
> Description:        not able to connect to postgres through the oracle using
> Details:

It's not at all clear that this is a PostgreSQL bug. You appear to be
reporting issues due to your configuration of the PostgreSQL ODBC driver
in an Oracle database where you are trying to use it for dblink.

The best place to ask for help about this is probably the EnterpriseDB
forums, as there are many Oracle users there.

You might want to collect up some more information when you do post
there, and take a minute to rewrite your explanation to be a bit
clearer. It is hard to understand exactly what you are doing and what
your problem is from the description you have posted.

Please only report bugs in the bug report form.

--
Craig Ringer