ID: 10206 Updated by: lobbin Reported By: [EMAIL PROTECTED] Old Status: Open Status: Feedback Bug Type: OCI8 related Operating System: IIS 4.0, NT Server 4.0 SP6 PHP Version: 4.0.4pl1 New Comment:
Sounds like an user error, did you get this right? Ff not, please try with latest release 4.1.1. Previous Comments: ------------------------------------------------------------------------ [2001-04-11 02:21:19] [EMAIL PROTECTED] Jani, php manual suggests to set such enviroment variables: ORACLE_HOME - seems to be path to a directory where an ORACLE product is. Am I right ? I've tried to set it as SET ORACLE_HOME=C:\ORANT and then run php C:\php4\php.exe c:\InetPub\wwwroot\test.php4 and I've got the same TNS-12154 error :-( Could you possibly tell, what's is going wrong ? P.S. I don't have any problems with php3 and Oracle on the same machine. ORACLE_SID - seems to be SID identifier, TNSNAMES.ORA already has got SID defined for my TNS alias. LD_PRELOAD - this variable seems to has meaning only for U*NIX systems LD_LIBRARY_PATH - this variable seems to has meaning only for U*NIX systems I can't guess what above two variables should contain on Win32 system. Could you possibly enlight me in this issue? NLS_LANG,ORA_NLS33 - these variables seem to contain NLS settings, so windows registry has it ------------------------------------------------------------------------ [2001-04-06 11:14:10] [EMAIL PROTECTED] Just wondering if you have all the necessary environment variables set? Check the manual page http://www.php.net/oci8 --Jani ------------------------------------------------------------------------ [2001-04-06 08:47:51] [EMAIL PROTECTED] When I use php in CGI mode any script can't connect to the Oracle DB throught the OCILogon call. When I switch to the ISAPI mode these scripts work OK. the sample script: <?php $dbuser="scott"; $dbpass="tiger"; $dbhost="devnt01"; if (! $dbconn=OCILogon($dbuser,$dbpass,$dbhost)) print("Cannot connect to oracle db '$dbhost' as user '$dbuser'"); ?> oracle reports: ORA-12154: TNS:could not resolve service name in C:\InetPub\wwwroot\test.php4 on line 5 ------------------------------------------------------------------------ Edit this bug report at http://bugs.php.net/?id=10206&edit=1 -- PHP Development 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]