Oracle HS to Postgres
GULAug 5 2008 — edited Sep 15 2008Hi all,
I'm trying to connect from Oracle 11g to PostgresSQL database using hs and db-link.
When I execute queries (select * from temp@postgres) I get error "FATAL: password authentication failed for user "user"[Microsoft][ODBC Driver Manager] Invalid connection string attribute".
I'm absolutely sure that user and password are right and I notice that Postgres database receive and empty password.
Also tnsping works.
This is my configuration:
Oracle 11g on Windows 2003 Server;
initPostgres.ora:
HS_FDS_CONNECT_INFO = postgres
HS_FDS_TRACE_LEVEL = 4
---------------------------------------
listener.ora
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = server-oracle)(PORT = 1521))
)
)
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(SID_NAME=postgres)
(ORACLE_HOME=D:\app\Administrator\product\11.1.0\db_1)
(PROGRAM=dg4odbc)
)
)
--------------------------------------
tnsnames.ora
# Connection to Postgres DSN
postgres =
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521))
(CONNECT_DATA=(SID=postgres))
(HS=OK)
)