How to Connect to Remote Oracle Database through PHP?

Is it possible to connect Oracle database without installing the Oracle client?

Oracle DB connect
Answer:

Yes. You can use an ODBC or JDBC driver. Here's more info, note that the Oracle supplied ODBC driver may require the client software, but you can get ODBC drivers from other places that do not. http://www.orafaq.com/wiki/ODBC_FAQ

Was this solution helpful to you?

Other answers

You need the Oracle JDBC Type-4 driver (the "thin" driver). http://www.oracle.com/technetwork/apps-tech/jdbc-112010-090769.html (you only need the ojdbc6.jar file) The standard Oracle JDBC driver requires that the OCI libraries (in other words, the Oracle client) are present. The same is true of ODBC, Perl, PHP, and other bindings. Note that the thin driver has some limitations, e.g. you cannot insert more than 2000 bytes in a column - so manipulating BLOB's is going to be problematic.

Orly Andico

Oracle database instant client http://www.oracle.com/technetwork/database/features/oci/index.html , JDBC ,ODBC ,php drivers with the oracle client libraries , most of these do not require the software to be "installed"

Sandesh Rao

Yes, programmatically using java code use jdbc to connect to oracle with ought oracle client. If you want to connect to oracle to work on stored procedures packages run queries etc, use oracle developer which do not require oracle client.

Aravind Kejri

Indirectly all software uses oracle client i.e OCI (Oracle Call Interface) to connect oracle server. So you can't conect oracle server with out oracle client, Oracle only allow to connect its server object only through own programme(OCI.dll) All SQL driver ,PL/SQL developer ODBC uses oracle client DLL i.e OCI.dll to connect oracle server and OCI.dll is written by oracle

Anil Dash

Yes you can use odbc drivers, http://easysoft.com create many useful drivers.

Haniff Din

in web base you can try to use zendserver, although there are several plugin for php or the other scripting language to connect to oracle. :) CMIIW

Adi Wirawan

Related Q & A:

Is it possible to migrate Oracle SOA BPEL instances from one environment to another with history?Best solution by Server Fault
Can I create a second filestream container on an existing SQL Server 2008 database without going offline?Best solution by Database Administrators
How to know the Oracle Database Name?Best solution by Stack Overflow
Is it possible to run Oracle Forms without applet?Best solution by Stack Overflow
Is It Possible to Connect a PC to a TV?Best solution by Yahoo! Answers

Just Added Q & A:

How many active mobile subscribers are there in China?Best solution by Quora
How to find the right vacation?Best solution by bookit.com
How To Make Your Own Primer?Best solution by thekrazycouponlady.com
How do you get the domain & range?Best solution by ChaCha
How do you open pop up blockers?Best solution by Yahoo! Answers

For every problem there is a solution! Proved by Solucija.

Got an issue and looking for advice?
Ask Solucija to search every corner of the Web for help.
Get workable solutions and helpful tips in a moment.

Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.