Re: Oracle 8 connectivity problems with Oracle 7 clients

HI,
Oracle 7.1 is not y2k compliant you need to upgrade to at least t.3.4 to be y2k compliant.

The network issue is going to be the least of your problems.

Jerry Gitomer wrote:
>
> You will have to install either SQL*Net v2 or Net 8 on your clients. Create a
> separate directory on each client and install the software in it . Use net
> easy (or whatever it is called) to set up your and test your connections to the
> 8i host.
>
> hth
>
> Manuel Mall wrote:
>
> > We have a small network with 3 Windows NT machines. One machine runs Oracle
> > 7.1 and all machines have the Oracle clients (16 bit), eg. SQL*Plus and
> > ODBC, installed. We also have a 16-bit VB application which connects to
> > Oracle.
> > On a second machine we have just installed Oracle 8i but we cannot "talk" to
> > it using the 16 bit clients from any of the workstations even its own. I am
> > sure it must be a networking installation / configuration problem. One
> > question is: What is the correct CONNECT string for Oracle 8i. For our
> > Oracle 7 server in our environment it is something like:
> > t:<hostname>:<sid>. But this doesn't appear to work for Oracle 8.
> > The basic things like Oracle 8 itself and the listener appear to work, ie.
> > on the workstation with Oracle 8 installed, we can use the Oracle 8 version
> > of SQL*Plus to connect to the Oracle 8 database by leaving the Host String
> > empty. But we are not able to use Oracle 8 SQL*Plus to connect to Oracle 7
> > using the t:<hostname>:<sid> string.
> > Any suggestions on what we might be doing wrong.
> >
> > Thanks
> >
> > Manuel
>
> --
> Once I figured out how to spell DBA I became one
> -- Jerry Gitomer
Received on Wed Jan 12 2000 - 21:20:51 CST