Home » SQL & PL/SQL » Client Tools » Connect to Oracle 7 from Oracle 10g (Oracle, 10g, Windows 2003)
Connect to Oracle 7 from Oracle 10g [message #434414] Wed, 09 December 2009 03:40 Go to next message
mrbaddy@rediffmail.com
Messages: 5
Registered: December 2009
Junior Member
Hello,

I am trying to build a data transfer interface between two servers.

Server 1: Oracle 7.x running on Unix server
Server 2: Oracle 10g running on Windows 2003 server.

Gateway Server: ???? on Windows XP(resides in the same network as Server 1).

I want to create a DB link from Server 2 (10g) to Gateway server which in turn connects to Server 1 (7x).

Using the DB links, I would like to process the data transfer between the two servers using multiple programs.

Could you please advise on the best Oracle version to use in the Gateway server so that Client connectivity is not an issue between (Server 2 & Gateway) & (Gateway & Server 1)?

Please note that connection will only be made in one direction as mentioned below.
Server 2 (10g) -> Gateway (??) -> Server 1 (7x).

Re: Connect to Oracle 7 from Oracle 10g [message #434415 is a reply to message #434414] Wed, 09 December 2009 03:41 Go to previous messageGo to next message
Michel Cadot
Messages: 63806
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Oracle 9.2

Regards
Michel
Re: Connect to Oracle 7 from Oracle 10g [message #434427 is a reply to message #434415] Wed, 09 December 2009 04:13 Go to previous messageGo to next message
mrbaddy@rediffmail.com
Messages: 5
Registered: December 2009
Junior Member
Thanks Michel for the quick response.

Any other versions just in case I could not get hold of 9.2.

Regards,
Badarinath
Re: Connect to Oracle 7 from Oracle 10g [message #434429 is a reply to message #434427] Wed, 09 December 2009 04:31 Go to previous messageGo to next message
Michel Cadot
Messages: 63806
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It is the best choice (and the only one still supported).
If you can't get this one which one you can get?

Regards
Michel
Re: Connect to Oracle 7 from Oracle 10g [message #434432 is a reply to message #434429] Wed, 09 December 2009 04:55 Go to previous messageGo to next message
mrbaddy@rediffmail.com
Messages: 5
Registered: December 2009
Junior Member
Thanks Michel.

I'll get 9.2.

I got more details about the server versions.

Server 1 is 7.1.2

Can I connect from Oracle 9.2 to 7.1.2?


Regards,
Badarinath
Re: Connect to Oracle 7 from Oracle 10g [message #434471 is a reply to message #434432] Wed, 09 December 2009 06:09 Go to previous message
Michel Cadot
Messages: 63806
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Not sure at all.
I didn't remember if 7.1.2 supports SQL*Net V2 or only SQL*Net V1. If it is only the latter, you will not do anything with any more or less current version.

Regards
Michel
Previous Topic: Installing Oracle 10g and PL/SQL on a 64bit machine w/ Windows 7
Next Topic: Like clause
Goto Forum:
  


Current Time: Tue Sep 27 12:45:28 CDT 2016

Total time taken to generate the page: 0.05385 seconds