Re: Silly question #44

On Wed, 13 Feb 2002 10:10:53 GMT, nsouto_at_optushome.com.au.nospam (Nuno Souto) wrote:

>Hi folks.
>I hate when people ask me this sort of thing. Always feel like
>sending them off to talk to an Oracle sales rep as punishment!
>
>
>If I have a Win2K workstation loaded with Oracle Client 8i release 3
>(whew, all that to say 8.1.7 client...), am I gonna have probs
>connecting to an 8.0.6 server? Net80, TCP/IP.
>
>I'm nearly 100% sure I won't, but I can't find any relevant
>confirmation in Metaclick or Technet. Or, I don't have the foggiest on
>the keywords to use for such a stupid question.
>
>I know, I know: suck it and see. If I could afford the time to do
>that, I would. Failing it, I have to rely on collective wisdom.
>
>TIA for any feedback.
>
>
>Cheers
>Nuno Souto
>nsouto_at_optushome.com.au.nospam

You need to give more details. How do you connect to the database (local naming, host naming or...?)

Can you connect to other databases (>8i) ?

If you use local naming ( tnsnames.ora) then post the entry in tnsnames.ora that is supposed to connect to the 8.0 database.

A common mistake is to use

  CONNECT_DATA =
      (SERVICE_NAME = MYDB) which is new with 8i. With 8.0 you need to USE

 CONNECT_DATA =
      (SID = MYDB) Regards,

• Kenneth Koenraadt