Re: Windows 2003, Oracle 7.3.3 Connection

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Thu, 4 Nov 2004 16:57:33 +1100
Message-ID: <4189c4b6$0$22631$afc38c87@news.optusnet.com.au>

"Thomas" <thomasatwork_at_hotmail.com> wrote in message news:d0099d9f.0411032034.3f804fec_at_posting.google.com...
> Hi Everyone,
>
> I am trying to setup the following -
> Windows 2003 Server with Oracle Client to connect to a oracle 7.3.3
> running under SCO Unix. This will be done via a Linked Server on SQL.
> The problem I have is that the Client I have that is supported by
> Oracle (9.2.0.2) (in win2k3) cannot be used to connect to DB 7.3.3. I
> have tried d/ling the Oracle Instant Client but its saying that the
> TNS:listener was not given the SID in CONNECT_DATA.
>
> Any ideas?

It's been mentioned before, I think, here. Since 9i won't talk to anything less than 7.3.4 (IIRC), the alternative is to have an intervening 8 or 8i database (which will happily talk to a 7.3.x database). You create database links from the 8 to the 7 database. Then the 9i client can query the 8 database link, the 8 database will fetch the data out of the 7 database, and everyone is happy. Apart from the performance tuning DBA who is shaking his head in disbelief!

Regards
HJR Received on Wed Nov 03 2004 - 23:57:33 CST