Re: Interfacing Oracle7 on HP-UX to MS IIS on NT 4.0

From your description of the problem, it seems that you have a couple of options :

If all your data is held within the Oracle database on UNIX, then one possibility is to use Oracle Web Application Server (WAS) 3.0. This product acts as a traditional web server, but with the added ability of interfacing directly with an Oacle database. This means that your NT machine is potentially not needed.

Alternatively, you could use Microsoft IIS as your Webserver, and access the data on the Oracle database using ODBC and SQL*NET. These middleware components are freely available for Windows platforms, in fact they should have come with your Oracle V7 server packaging on a CD titled 'Oracle Client Software for Windows95/NT'. You can even download freebies from the Oracle website.

If you decide to use IIS, you don't need to code in PL/SQL and can do everything using Active Server Pages (a kind of dynamic scripting language)

The Webserver solution is probably faster, more scalable and frees up your NT machine.

The IIS approach is slower and less scalable, but proably cheaper depending on your licence arrangements with Oracle. Also the Microsoft development tools are better, and will integrate with databases other that Oracle (SQL Server etc).

HTH Steve

gigbrown_at_my-dejanews.com wrote:

> I am working on a project that requires interfacing an Oracle 7.3 server,
> running on an HP-UX host, to a MS Internet Information Server, running on an
> NT 4.0 host. All servers are connected via a TCP/IP network. The objective
> is to allow users to query the database from forms presented via ANY web
> browser on ANY platform. I am planning on using PL/SQL or CGI scripts to
> build the web pages dynamically.
>
> I believe the key to successfully interfacing the two is Oracle's Web Server
> 1.0 product or its shareware predecessor WOW. But I cannot seem to locate
> either of these. Furthermore, Oracle supports neither; so they were of little
> help. Any leads to where these packages can be obtained?
>
> Another possibility might be SQL*Net drivers for both hosts, since I believe
> this is the default protocol, and thus a required component, of the WebServer
> product. Is the SQL*Net driver in Personal Oracle7 for Windows95/NT
> compatible with IIS? Is this the same driver that is distributed in Oracle's
> WebServer 2 or 3 product? And will it talk to SQL*Net on the Unix host?
>
> Another goose chase seems to be ODBC drivers for HP-UX. The theory behind
> this one is that IIS can parlez via ODBC to the Oracle7 server. Does anyone
> know if such a driver exists?
>
> Any and all help will be greatly appreciated! Thank you in advance,
> Gig
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/ Now offering spam-free web-based newsreading
Received on Tue May 19 1998 - 05:09:07 CDT