Re: More on trying to get started with Oracle

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: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net