Ora_Logon Help

[Elknox]

I am using the following code to ty to connect to an Oracle database and I get the error at the bottom - any assistance is appreciated.
Code:
//************************************************
<?php
putenv("ORACLE_SID=Test");
putenv("ORACLE_HOME=/full Path/oracle/product/8.1.5");
$connection = Ora_Logon("TP_TEST","testpw");
if ($connection == false){
echo Ora_ErrorCode($connection) . ": " . Ora_Error($connection) . "<BR>";
exit;
}
$cursor = Ora_Open($connection);
if ($cursor == false){
echo Ora_ErrorCode($connection) . ": " . Ora_Error($connection) . "<BR>";
exit;
}
?>
//**********************************************************************************

Error Message:
Warning: Oracle: Connection Failed: ORA-12547: TNS:lost contact in /path/filename.php on line 4

Warning: ora_errorcode(): supplied argument is not a valid Oracle-Connection/Cursor resource in /path/filename.php on line 6

Warning: ora_error(): supplied argument is not a valid Oracle-Connection/Cursor resource in /path/filename.php on line 6

[axsdeny]

Are you sure this is right?

putenv("ORACLE_HOME=/full Path/oracle/product/8.1.5");

You have to replace that 'Full Path' part with the actual path...

[piersk]

If you are using oracle 8, i think there are some seperate functions for them...try http://www.php.net/manual/en/ref.oci8.php

[jmcneese]

or use PEAR, like i do:

require_once("DB.php");

$user = "user";
$pass = "pass";
$db_name = "db";
$dsn = "oci8://$user:$pass@$db_name";
$db = DB::connect($dsn, true);

if (DB::isError($db)) {
   die ($db->getMessage());
}

[piersk]

Either way is good... 😃