Networks

Ask something
Discussion Locked

Web Server Oracle database connection

0 helpful
5 replies

by campbellwj

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have a web server that is in the DMZ. I also have a NT server on the corporate internal network. This server is running Oracle 8. I would like to have customers from around the world to view the web server and have the web server pull information from the internal Oracle server. How do I accomplish this? Do I have to open a port in the firewall? Do I need additonal software? This is a very important project I am working on. I would appreciate any assistance. It is worth many many points..Thank you. You can send replies to williamc@ectel.com

5 replies

by raffi_

You should not need any additional software for this.

At its most basic level all you really want to do is pass HTTP requests from your web server to your Oracle server. That means at least that the firewall must pass port 80 requests.

A simple method of connecting your web site to your DB would be via ODBC. Your site "knows" where the DB is and can provide all of the proper authentication to both the NT authentication and the Oracle login.

You did not mention details such as the type of web server (Apache?, IIS4? IIS5? Domino?)or the scripting language used.

email me direct if you need additional help.
raffi@tec-man.com

Regards
Raffi_

by nialadrol

Hi,

You should install Oracle SQL*Net (a.k.a. Net8) software on the Web server side in order to establish connection(s) with your Oracle DBMS, if your application code is running under the Web server.

Regards,

Alain

This discussion is closed to new replies.