This seems to be a common problem, I dont know why PHP doesnt make a note of
this on their website under the Oracle documenation.
The problem is that PHP/Apache needs to know these variables upon server
startup, not when it loads the specific PHP page.
So what you need to do is set these variables in your apache httpd.conf like
this:
SetEnv TNS_ADMIN ???
SetEnv ORACLE_HOME ???
SetEnv ORACLE_SID ???
That is all I set in my config and it works great. Then you use the
user/password on the php page, and it should work..
good luck
/cody caughlan
John Coonrod wrote:
> OK, I've now figured out how to activate the oracle commands and get php4 to
> recognize them, but I cannot get the connection to connect. This is under
> windows 2000: I've putenv oracle_home, oracle_sid and tns_admin and
> ora_logon with the same name@tns and password that work under sqlplus - and
> ora_logon fails.
>
> --
> PHP Database 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]
--
PHP Database 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]
