Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-odbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group