Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Oracle 8 connectivity problems with Oracle 7 clients

Oracle 8 connectivity problems with Oracle 7 clients

From: Manuel Mall <mmnospam_at_arcus.com.au>
Date: Wed, 22 Dec 1999 09:48:44 GMT
Message-ID: <945856124.242848@hearts.q-net.net.au>


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 Received on Wed Dec 22 1999 - 03:48:44 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US