Re: How to connect to a database on a remote server

From: Andrew Hardy <nobody_at_spam.from.news.AdvanticaTech.com>
Date: Thu, 13 Sep 2001 09:52:46 +0100
Message-ID: <9nps5f$een$1@sun-cc204.lut.ac.uk>

You need to look at your documents for TNSNAMES which is used for connecting to databases.

The TNSNAMES.ORA file on your client has the name that you want to connect with, the name of the machine holding the database and the name of the database itself.

Andy
"William Quenum" <willy.quenum_at_sympatico.ca> wrote in message news:3BA06CDD.C53D12CB_at_sympatico.ca...
> Hi all:
>
> Oracle enterprise has been installed on my computer lately. I want to
> connect to a database which is on another network. If the physical
> address of the server is:
>
> example.dhb.ca\access_prod
>
> and the name of the server: ORA_MaintData
>
> The startup form to load is MaintDb.frm (frm or fmx ?)
>
> How do I set up Oracle to point toward the backend posted on
> ORA_MaintData
>
> I am quite new in Oracle and confused. Can anybody clarify it for me a
> bit?
>
> Thanks
>
> William
>
Received on Thu Sep 13 2001 - 03:52:46 CDT