Oracle Heterogenous Services Error - Mailing list pgsql-odbc

From LLC
Subject Oracle Heterogenous Services Error
Date
Msg-id 1150841779.v2.fusewebmail-164106@ffuse12
Whole thread Raw
Responses Re: Oracle Heterogenous Services Error
List pgsql-odbc
Hi List;

We've setup oracle HS-ODBC on Oracle 10g installed on a windowsXP box. We
also have Postgres installed on a redhat Linux box.

I've setup a user 'pgadmin' for testing.  I've added an entry in the
pg_hba.conf file as follows:

host    all         all         0.0.0.0/0  md5

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

Anyone have any Ideas??

Thanks in advance for your help...



pgsql-odbc by date:

Previous
From: "Mike Kock"
Date:
Subject: Access and autonumbers (serial)
Next
From: "LLC"
Date:
Subject: Cannot wrap stored procs in transaction via sql server link