Connect to Oracle 7 from Oracle 10g [message #434414] |
Wed, 09 December 2009 03:40  |
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 #434471 is a reply to message #434432] |
Wed, 09 December 2009 06:09  |
 |
Michel Cadot
Messages: 68737 Registered: March 2007 Location: Saint-Maur, France, https...
|
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
|
|
|