note 54508 added to function.ocilogon

From: Date: Wed, 06 Jul 2005 15:51:32 +0000
Subject: note 54508 added to function.ocilogon
Groups: php.notes 
Request: Send a blank email to php-notes+get-91538@lists.php.net to get a copy of this message
I spent ages trying work out why I was getting the following message when when using ocilogon() on Windows 2000 using PHP 4 and 5: ORA-03106 Fatal two-task communication protocol error This problem is occurs when PHP cannot find ORACLE client environmental variables. The environmental variables can be set in several ways: 1. Within the root 'Directory' directive on Apache httpd.conf: <Directory "d:/path/to/webroot"> SetEnv ORACLE_BASE "c:/oracle" SetEnv ORACLE_HOME "c:/oracle/ora81" SetEnv NLS_LANG "american_america.WE8DEC" SetEnv NLS_CHARACTERSET "WE8DEC" SetEnv NLS_NCHAR_CHARACTERSET "AL16UTF16" </Directory> or 2. Within Windows: Go to the Control Panel>System>Advanced>Environmental Variables Then enter a name value/pair for each of the variables. 3. Using putenv() statements in the PHP file prior to using ocilogon(). This is not ideal because the statements are required evertime you wish to connect to Oracle. ---- Manual Page -- http://www.php.net/manual/en/function.ocilogon.php Edit -- http://master.php.net/manage/user-notes.php?action=edit+54508 Delete: added to the manual -- http://master.php.net/manage/user-notes.php?action=delete+54508&report=yes&reason=added+to+the+manual Delete: bad code -- http://master.php.net/manage/user-notes.php?action=delete+54508&report=yes&reason=bad+code Delete: spam -- http://master.php.net/manage/user-notes.php?action=delete+54508&report=yes&reason=spam Delete: useless -- http://master.php.net/manage/user-notes.php?action=delete+54508&report=yes&reason=useless Delete: non-english -- http://master.php.net/manage/user-notes.php?action=delete+54508&report=yes&reason=non-english Delete: other reasons -- http://master.php.net/manage/user-notes.php?action=delete+54508&report=yes Reject -- http://master.php.net/manage/user-notes.php?action=reject+54508&report=yes Search -- http://master.php.net/manage/user-notes.php

« previous php.notes (#91538) next »