Oracle Heterogenous Services Error

From: "LLC" <kevin(at)kevinkempterllc(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Oracle Heterogenous Services Error
Date: 2006-06-20 22:16:19
Message-ID: 1150841779.v2.fusewebmail-164106@ffuse12
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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...

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message LLC 2006-06-21 00:04:39 Cannot wrap stored procs in transaction via sql server link
Previous Message Mike Kock 2006-06-20 17:07:57 Access and autonumbers (serial)