Still can't talk to the Oracle
| From: | Kristofer Widholm | Date: | Tue, 13 Feb 2001 23:30:55 +0000 |
| Subject: | Still can't talk to the Oracle | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-39526@lists.php.net to get a copy of this message | ||
I'm setting up a back end production system for a television show, and have been given space on a development server with PHP 4 and Oracle support compiled in (but not the OCI libraries). The Oracle admin have given me my user name (let's say ora_user), a TNS name (tns_name), and a password (ora_pass).
So I write code as follows...
if ($conn=ora_logon("ora_user@tns_name","ora_pass")) {
echo "SUCCESS ! Connected to database\n";
} else {
echo "Failed :-( Could not connect to database\n";
echo ora_errorcode($conn).": ".ora_error($conn)."<BR>";
}
In response to this code, I get the following error:
ORA-12154 "Supplied argument is not a valid Oracle-Connection/Cursor resource in ...."
From reading php.net documentation on ora_logon, it seemed that maybe the ORACLE_HOME environment variable simply hadn't been set.
I had the sys admins set it.
And I still get the error.
Any ideas from an experienced PHP/Oracle developer?
Kristofer