Re: How to interface WWW Unix server with Novell oracle server
Date: 1995/07/06
Message-ID: <3th63i$ap3_at_inet-nntp-gw-1.us.oracle.com>#1/1
hawk_at_xs4all.nl wrote:
>Hello,
>We have the following a Silicon Graphics machine as Web Server,
>a Oracle Server on Novell. So we need to interface the Web pages with
>info on the Oracle server.
>Proble what do we need, and must of all we're to get more info. What do I know:
>We need client-novell kit to get SG to communicate with novell
>Something called WOW (Interface kit oracle and Webpages)
>But I think I should also need client-software for the SG machine to connect
>with the oracle database.
>Further is there something in a FAQ, or is there soemwhere more info. The
>Dutch representatives of Oracle and SG where helpfull, but didn't seem to be
>very experienced in the matter.
>Greetings,
>Jan Willem
>-----
>Fransen_at_thing.xs4all.nl
Jan - look under "Free Trial Software" on the Oracle home page at http://www.oracle.com for the Oracle World Wide Web Interface Kit.
The interface kit contains a lot of independent pieces, authored by various Oracle users around the world. The WOW piece was created by Oracle. It consists of two main components - (1) a stub written in C that is called from CGI, and it in turn calls into Oracle7 stored procedures; - (2) a set of stored procedures, written in PL/SQL. You write an application as additional stored procedures, which can do almost anything you can think of, including of course simple SQL queries. See the Auto Dealer example online at http://dozer.us.oracle.com:8080 for some ideas.
There are two ways to use this with any particular platform. The most common way is to have a Web server, CGI-stub, and Oracle7 on a single machine.
A second way to use the WOW approach is to split the system across two platforms. A Web Server and CGI-stub would be on one platform, and Oracle7 on another platform with some network connecting the two. You need SQL*Net on both platforms so that the Web Server/CGI-stub can communicate with the database. In effect, the CGI-stub is just a client of the database, and communicates with the database either on the same physical machine or to a remote server over any kind of network by using SQL*Net.
The second approach is very popular for providing Web interfaces with existing databases. For example, your Web Server running on an SGI machine with the CGI-stub and SQL*Net could be using a database (and the data) running on the Novell server machine, also with SQL*Net.
The communications between the two could be TCP/IP, or it could be anything else, such as SPX/IPX. Your choice, depending on what's best for your installation.