Connecting a postgresql client to an oracle7 db

From: Dominique Duflos <Dominique(dot)Duflos(at)alcatel(dot)fr>
To: pgsql-novice(at)postgresql(dot)org
Subject: Connecting a postgresql client to an oracle7 db
Date: 2002-02-06 15:03:40
Message-ID: 3C6145CB.787EDB95@alcatel.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Philip Neukom 2002-02-06 15:31:31 Is there an opensource Mac OSX equivalent to pgAdmin or pgAccess?
Previous Message Stephen Ingram 2002-02-06 06:09:53 Re: user-defined not working