Re: Windows 2003, Oracle 7.3.3 Connection

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?

I'm not sure exactly what you are trying to do. It may make the difference. But, here are some ideas.

How about loading the VMWare Workstation on your 2003 server, then create an NT4 VM and load the 7.3.x client stuff. Then you can run SQL*Plus and v7.x utilities in the VM, and your client is actually 'on' the W2003 server. While this seems stupid, it may have a few 'advantages' you need.

Another idea is to run cygwin on W2003, and run secure remote to an account on the 7.3.x server. However, I don't know if SCO Unix serves the OpenSSL and X11 stuff like LINUX so this might be hard to secure. And, I don't know if you are allowed to 'play' on the server.

Good luck with the other workarounds.

Regards,

Mike Received on Fri Nov 05 2004 - 01:22:59 CST