Re: [HELP] How to read Oracle from the Internet?

From: Daniel Lisiecki <lisu_at_venus.wmid.amu.edu.pl>
Date: Thu, 12 Aug 1999 08:47:13 GMT
Message-ID: <lSvs3.13486$X3.210668_at_news.tpnet.pl>


I haven't experience in C++,Java,HTML, and JavaScript, :-) but under NT in \Start Menu\Programs\Oracle for Windows NT I found two programs: Net8EasyConfig and Net8Assistant. In those programs You can define the oracle server name and location (name.domain or IP), and protocol (for example TCP). After You define this params you can acces database on foreign host with any program using connection string <user>/<passwd>_at_<defined_database_service>. An user, that want to connect to foreign host must have Oracle client installed. When you have Pro*C (oracle classes for C++) installed on your system you can write any function you need to connect to database. Oracle Server runs the listener on port 1521.

Daniel Lisiecki
Poznan, Poland
lisu_at_venus.wmid.amu.edu.pl

P.S. I've tested this connection using telnet from foreign host to my LAN OraServer on port 1521. It.works.

John <jawohl_at_my-deja.com> wrote in message news:7ot0n4$mc$1_at_nnrp1.deja.com...
> ************************
> *** MY BACKGROUND: ***
> I just got a job as a web developer. I am working on a master's in CS
> and have experience programming in C++/Java, so I can understand
> whatever you care to reply with. I completed Oracle 7 courses five
> years ago (when the web was inchoate), took them quite seriously, and
> took good notes.
>
> My notes brought me back up to speed on Oracle, SQL, SQL*Plus, and
> SQL/PL, no problem. (Whew.) I also know a lot of HTML & JavaScript &
> what little XML there is at this point. Know Unix/NT.
>
> ******************
> *** MY NEED: ***
> I have to write some methods (an API) so that developers at other
> companies can read our Oracle tables over the Internet without having
> to come to our web site, i.e., other developers could call our database
> and show the results in their web pages.
>
> My dilemma: I am reading everything everywhere (including oracle.com
> and java.sun.com) about tools that I *think* will allow me to do this:
> JDBC, Oracle Application Server (OAS), WebDB, etc. Which one's least
> painful to learn? I know that 3-tiered JDBC is preferable to 2-tiered
> for scalability, but it's also harder (to write that middle layer). I
> am getting nervous because I want to come up with something tangible
> besides this document describing the functions to read our tables.
> What should I learn? Continue with JDBC? Or use an Oracle product?
> Both? I HAVE NEVER written code to access an ORACLE TABLE from across
> the Internet! Java could be a good fit since it's relatively easy to
> write threads and has security for the 'net. This place currently has
> Oracle tables connected to web pages via CGI/Perl and they want to get
> away from that.
>
> ------------------------------------------------------
> HAVE ANY OF YOU ACCESSED ORACLE TABLES FROM ACROSS THE INTERNET? HOW?
> ------------------------------------------------------
>
> ANY words of advice will be greatly comforting. Help-help-help-help-
> help! I feel powerless and mal-qualified. If I can just read a sample
> Oracle table over the 'net with some code I will relax. No, I will
> *cream.* I have different ISP's to test stuff out with and an Oracle
> account so I can make sample tables on our server, etc.
>
> *Thanks* everybody, and sorry for the cross-post.
>
> John
>
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Thu Aug 12 1999 - 10:47:13 CEST

Original text of this message