Connecting to Oracle from Web

[yorkyporky]

Hello,

Althouhg I've been using Oracle for the last few years, it has mostly been with v7 and 8.0.5, so most of the internet capability has passed me by.

I wondered if any one had any tips or new of any web sites that could give me some basic, newbie type information on how to start geting a nerw application talking to an oracle DB via the web. I think I've started to grasp the basics, but most of the stuff I've found seems to miss out the 'hello world' stage.

Thanks

YP

 

[IThead]

You need to setup an ODBC connection to your oracle database, and insert your sql statements in your web page.

 

[Highrisk]

Hello YP,

It's very simple to use the oracle database as back end on web. You may access the Oracle database through ASP or Coldfusion ( I used to develop applications in asp and colsfusion). If you are access the database through ASP then u have to create a DSN on the machine where IIS ( Internet Information Server ) is running and then include this DSN in the asp files for opening the connection to the Oracle database.

If you need more assistance than can contact me on naseermh@bp.com

Regards,

 

[sem]

If you're on 8i you may use Oracle Webserver without any need of IIS or ODBC. In fact it's a combination of Apache (webserver, JServ) and Oracle (modplsql, bc4j) software. So you may use JSP/Servlets or pure pl/sql to develop your website.