Re: Windows 2003, Oracle 7.3.3 Connection

bdbafh_at_gmail.com (Paul Drake) wrote in message news:<910046b4.0411040839.7bf4fbdc_at_posting.google.com>...
> thomasatwork_at_hotmail.com (Thomas) 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?
>
> - You could sell umbrellas outside of New York Penn Station on rainy days.
> - join the Peace Corps
> - Nuke the SCO box and install your favorite Linux distro
>
> 7.3.3 on SCO is the most evil combination I have ever heard of.
>
> Somehow, I feel so much better after hearing of your grief.
>
> -bdbafh
>
> "the blues ain't about feeling bad, its about making other people feel worse"
> - Bleeding Gums Murphy

Thanks for the reply guys. Sorry if it had been mentioned before, I havn't been able to find anything that matches that combination; The instant client doesn't work either (in case you were wondering) - it said this version is no longer supported; I have contacted the software vendor (as this sco / oracle) combination is from a company that we have recently took over, and due to the complexity of the software, we don't have the budget or the resources to rewrite the app, so we need to get the data into one area. I will explore the option of the Oracle 8 personal edition, linked to the 7.3.3 and then have the 9i linked to the Oracle 8. The performance shouldn't be an issue given that I am not using the data live, I will d/l @ a certain time every day.

Thanks for the reply, will keep u posted on my results. Received on Fri Nov 05 2004 - 04:42:07 CST