Re: Connecting to Oracle database over the internet

In article <63na5a$cpb_at_news9.noc.netcom.net>,   "Craig M. Wall" <cwall_at_petersons.com> wrote:
>
> As far as I know, all client connections to remote databases over IP require
> the presence of SQL*Net connectivity software on both machines to provide a
> substrate or transport mechanism for non-native access methods such as OLE,
> ODBC, Livewire, Perl, etc.
>
> On the client side, you'll need Oracle's SQL*Net for TCP/IP, most likely
> version 2.x. Then you must configure the tnsnames.ora file on the client to
> associate an alias for the instance name you are attempting to connect to
> and it's IP address.
>
> Then you will use this alias in your tool's connect string (along with
> username & password) when it logs into the database. This also assumes that
> if a firewall proxy server is in place it is configured to pass SQL*Net
> packets or if it's just a router, that your remote IP address is allowed to
> be forwarded to the database host.
>
> Regards,
> Craig M. Wall
>
> Steve wrote in message <345f54d3.6648326_at_news.ais.net>...
> >I am trying to attach to an Oracle server running on a remote system
> >through it's IP address on the internet. The web server is a sun
> >machine and I am looking for a way to do this through Perl. How do
> >you connect to remote Oracle servers through their IP over the
> >internet? Thanks.
> >
> >Steve

ACtually, SimbaExpress from Simba TEchnologies (http://www.simba.com) let's you connect to Oracle over the Net without having to put SQLNet on the client machine. It uses a 3-tier structure to make ODBC over the Net FAST and manageable.

To see what I mean, point your browser at http://www.simba.com/demos/online.html and try out one of their online demos. You just download an app that contains the ODBC driver (no need for SQLNet on your computer) and you can connect to an Oracle db over the Net

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet