PHP and Oracle (ugh) Permissions Issue???
Posted: Mon Jan 31, 2005 12:16 pm
I have oracle installed on a server (A) that I connect to via another box (B). All the proper oracle stuff is installed on B and I'm able to connect to oracle with PHP command line scripts. When I try to use the *exact* some code within a script that gets served by apache, I get errors that state it's unable to connect to the DB...
Here's the code I'm using to connect:
Works fine when I run the script from the command line, fails terribly when I'm using it in a web page...
Any thoughts?
Thanks,
~Scott
Here's the code I'm using to connect:
Code: Select all
$db = "dbname"; $user = "username"; $pass = "password";
$conn = oci_connect($user, $pass, $db);
$query = oci_parse($conn, "select * from some_table");
oci_execute($query);
oci_fetch_all($query, $results);
oci_close($conn);Any thoughts?
Thanks,
~Scott