Connecting a postgresql client to an oracle7 db - Mailing list pgsql-novice

From Dominique Duflos
Subject Connecting a postgresql client to an oracle7 db
Date
Msg-id 3C6145CB.787EDB95@alcatel.fr
Whole thread Raw
Responses Re: Connecting a postgresql client to an oracle7 db  ("Josh Berkus" <josh@agliodbs.com>)
List pgsql-novice
Hello,
Is it possible to connect the postgresql program psql to an oracle7
database ?

When I tried I got:

bash$ psql -h nan -p 1526 satbase
psql: PQconnectDB() -- couldn't read postmaster response: errno=2
No such file or directory

and on the server side the listener.log file reads:

 05-FEB-02 16:36:51 * 12569
 TNS-12569: TNS:packet checksum failure

On the network, tcpdump saw this:

17:08:35.251072 eth1 > desire.45256 > nantes.1526: S
774363043:774363043(0) win 5840 <mss
17:08:35.261072 eth1 < nantes.1526 > desire.45256: S
499968000:499968000(0) ack 774363044
17:08:35.261072 eth1 > desire.45256 > nantes.1526: . 1:1(0) ack 1 win
5840 (DF)
17:08:35.261072 eth1 > desire.45256 > nantes.1526: P 1:297(296) ack 1
win 5840 (DF)
17:08:35.271072 eth1 < nantes.1526 > desire.45256: F 1:1(0) ack 297 win
32768 (DF)
17:08:35.271072 eth1 > desire.45256 > nantes.1526: F 297:297(0) ack 2
win 5840 (DF)
17:08:35.271072 eth1 < nantes.1526 > desire.45256: . 2:2(0) ack 298 win
32768 (DF)

Thank you for any help.
Dominique Duflos


pgsql-novice by date:

Previous
From: Stephen Ingram
Date:
Subject: Re: user-defined not working
Next
From: Philip Neukom
Date:
Subject: Is there an opensource Mac OSX equivalent to pgAdmin or pgAccess?