Re: How to connect to Oracle over internet.

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 11 Oct 2001 22:49:05 +0200
Message-ID: <tsc1egehc1d585@news.demon.nl>

"slycat" <slycat_nospam_at_yahoo.com> wrote in message news:51e75926.0110111233.33df8809_at_posting.google.com...
> I was wondering if anyone might know the answer. I need to set up a
> System DSN on a Windows machine that will reference an Oracle
> database. I was able to set it up with Oracle running on the same
> machine that I set the DSN on.
>
> My question is, with Oracle running on a remote machine(internet), do
> you know the syntax for the server name? Since it will no longer be
> local? The DSN type is MS ODBC for Oracle. This is driving me nuts!
> How do i get to it? domain name/ip?

Please read the net8 manual and stop posting this question every hour. Usenet is a volunteer business.
You need to configure net8 and copy tnsnames.ora and sqlnet.ora to any client using the database.
If your server has a DNS address you shouldn't use an IP address *anywhere*

Regards,

Sybrand Bakker
Senior Oracle DBA Received on Thu Oct 11 2001 - 15:49:05 CDT