Connecting to Oracle from PHP4.

Anon

Hi,

I have a problem making a connection to Oracle 8.1.6 using PHP4 on RedHat 6.2.

$or_conn=Ora_Logon("system@or8", "pwd");

$dbstring="or8";
$oci_conn = ocilogon("system", "pwd", $dbstring);

I get the following errors:

Warning: Oracle: Connection Failed: Error while trying to retrieve text for
error ORA-12154 in db.php on line 18

Warning: _oci_open_server: Error while trying to retrieve text for error
ORA-12154 in db.php on line 21

Anyone got any thoughts on what I'm doing wrong? I can connect to Oracle via SQLPlus just fine.

Thanks v.much,
Cheers Roland.

Anon

Check to make sure that the service "or8" is defined in your tnsnames.ora.

-- Michael
Darkstreak Consulting
www.darkstreak.com

Anon

Hi Roland,

This may be a silly question but is the php binary that you are calling compiled with --with-oci8 configure option? You will need that to connect. Other than that your code seems OK.

Geordie

Anon

Thanks for your reply.

It is, I compiled it myself. I actually found a way of getting it to work ... I had to put

putenv("ORACLE_SID=ORACLE");
putenv("ORACLE_HOME=/opt/oracle/oracle/8.0.3");

at the top of the .PHP page. Not exactly those values, but you get the idea.

Does this strike you as wrong?
Cheers Roland.