OCI uses - Codewalkers

Codewalkers Forums Sponsor:

January 4th, 2005, 11:34 PM

madie

Join Date: Apr 2007

Location: K. Trg, Malaysia

Posts: 55

Time spent in forums: < 1 sec
Reputation Power: 2

OCI uses

Hi...

i'm facing problem in how to configure OCI with my php box..

the situation is like this:

i have an Oracle9i Database on Sun Solaris.

and i have php in linux on different machine.

Question:
if i want to connet to my oracle database which is installed on sun solaris, is it possible to do this?

prompt reply is appreciated..

tq

January 5th, 2005, 01:49 PM

nawlej

Contributing User

Join Date: Apr 2007

Location: Dallas, Tx. USA

Posts: 2,008

Time spent in forums: 11 h 7 m 51 sec
Reputation Power: 4

RE: OCI uses

Using OCILogon():

php Code:

Original - php Code
$db = "(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = <i>ip.address.of.db</i>)(PORT = <i>db.port</i>)) ) (CONNECT_DATA = (SID = <i>YOUR_DB_SID</i>) ) )"; $con = OCILogon("user", "password",$db);

 
$db = "(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = ip.address.of.db)(PORT = db.port)) ) (CONNECT_DATA = (SID = YOUR_DB_SID) ) )"; 
$con = OCILogon("user", "password",$db);

Basically, you just have to build out a connection hash. This information is located in your tnsnames.ora file on the db server

Viewing: Codewalkers Forums > PHP Related > PHP Installation > OCI uses

« Previous Thread | Next Thread »

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox

Forum Jump