----- Original Message -----
From: Kristofer Widholm <[EMAIL PROTECTED]>
Newsgroups: php.general
Sent: Tuesday, February 13, 2001 5:29 PM
Subject: [PHP] Still can't talk to the Oracle
> 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...
You may need to set ORACLE_HOME etc in PHP's environment:
SetEnv("ORACLE_HOME=/path/to/oracle/home/dir");
SetEnv("ORACLE_GOD_KNOWS_WHAT_ELSE=/oracle/changes/it/every/release");
> 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?
Also, if $conn isn't a valid connection, ora_errorcode() probably can't be
used on it.
It's a chicken and egg problem -- Until you have a valid connection, you
can't get the error message about why the connection failed...
Try echo $php_errormsg
--
Visit the Zend Store at http://www.zend.com/store/
Wanna help me out? Like Music? Buy a CD: http://l-i-e.com/artists.htm
Volunteer a little time: http://chatmusic.com/volunteer.htm
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
