Click to See Complete Forum and Search --> : Win98 Oracle8i and Apache1.3 Problem


Anon
12-07-2001, 05:47 PM
OS: Windows 98
DB: Oracle8i (personal edition)
HTTPD: Apache 1.3
PHP: 4.0.6

I've got just about everything setup. I have the following snippet of code that I'm trying to run in test.php:

test.php:
<?php
print "<PRE>";
print phpinfo();
$db = "acsdev";
$c1 = ocilogon("system","manager",$db);
print "c1=[$c1]<br>";
exit("</pre>");
?>

When I run the script at the windows prompt:
C:\Program Files\Apache Group\Apache\htdocs>c:\php\php.exe -q test.php

I get the expected output:
<PRE>c1=[Resource id #3]<br></pre>

However, when I start apache:
C:\> set APACHE_HOME="C:\Program Files\Apache Group\Apache"
C:\> set ORACLE_HOME="C:\Oracle\ora81"
C:\> set ORACLE_SID="acsdev"
C:\> set ORACLE_BASE="C:\Oracle"
C:\> %APACHE_HOME%\Apache.exe -w -f %APACHE_HOME%\conf\httpd.conf -d %APACHE_HOME%

And then try to get http://localhost/test.php I get the following error:

Warning: _oci_open_server: Error while trying to retrieve text for error ORA-12154

I have a feeling that Apache 1.3 is not starting PHP 4.0.6. correctly, somehow the php_oci8.dll looks like it's not getting linked properly. Am I missing some kind of environment variable?

I can use SQLPLUS no problem to login to the oracle instance.

Any suggestions?

Regards,
seth