On Friday 19 May 2006 00:11, Trusha wrote:
> ... how to connect to oracle server
> from the web server using php ? ...

The obvious solution is PHP's Oracle support. But that requires installing
Oracle client components on the PHP machine.

An alternative might be a PHP interface to JDBC Type 4 drivers calling through
to Oracle. Type 4 drivers are supposed to be generic on the client end, so
there'd be no proprietary software to install with PHP. I haven't looked
into this for a while, but options in this area seemed "primitive" at best.

Another option I want to explore is to enable Oracle XMLDB which comes with
its own HTTP listener. Then implement XML result streams through that
interface, and you have a mechanism for "touching" Oracle via an URL/URI/IRI,
and PHP supports all the pieces pretty much "out of the box". Don't know
what the performance, etc. issues will be with this, but it looks interesting
to me for its simplicty and supportability once the XMLDB stuff is
configured. Oh, and 10gR2 is, I believe, the first XMLDB release
with /official/ support for enabling SSL on XMLDB's HTTP listener.

HTH ... Barry J.

--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting