URGENT: OCI8 doesnt work! Apache, NT, php4win 4.02

Anon

I have downloaded the PHP 4 distribution from www.php4win.de and followed
all the instructions etc, everything is woking. I see the phpinfo() etc.I can also connect to Oracle through ODBC. But, OCI doesnt work! 🙁

A part of the httpd.conf file:

#--------------------------------------------# THE PHP DIRECTORY STUFF
#--------------------------------------------LoadModule php4_module modules/mod_php4/sapi/php4apache.dll
AddType application/x-httpd-php .php4 .php

#---// FOR ORACLE >>
SetEnv ORACLE_HOME "C:\Oracle\Ora816"
SetEnv TNS_ADMIN "C:\Oracle\Ora816\network\ADMIN"
#--------------------------------------------

Now, my program cannot do a simple OCILogon as well!!!!

I would greatly appreciate any help!!! THANKS in ADVANCE!!!!

Best regards,
Ben H.

Anon

Load php as a module .dll for apache becuase otherwise it will not register those variables that you put in with the system. I had the same problem and that was my fix.....i don't remember the name of the module but i think it shows in a readme how to......ohhh looking at your code all you need to do is unhighlight the LoadModule php4_module part........good luck

Daniel E. Shipton

Anon

I downloaded PHP4 from the same website and using 1.3.12 of Apache. The only diff is that I am using php.exe rather than module.

Try exe and see if it works.

Roman

Anon

Hi,

I am now running PHP as a module (inside Apache) and everything is working fine. The ODBC executes perfectly. But the OCI and the ORACLE functions carp out.

I tried uncommenting the php_oci8.dll in the php.ini, but it crashes my APACHE, it doesnt even start.

What now? IS there something I am missing? I have installed the Oracle client (8.1.6.0.0) again (in a new ORACLE_HOME) and this is reflected in my httpd.conf. I can use SQL*Plus easily..

I have really read all the newsgroups, messages etc, but to no avail! Could it be a windows 2000 calamity? Does anyone have it working on win2k?

Plesaaaase heeeelllp!!

Thanks
Ben

Anon

Hi Roman,

Can you pls pass me the PHP-related part of your httpd.conf file? Thanks..I did try the exe before shifting to the module, but with the exe I could not execute PHP at all! 🙁

At least now, I have the ODBC functions working..

Thanks in advance
Ben

Anon

Ben,

If you have sql plus running you do not need to set the enviroment variables (check by looking in the properties for My Compter) you do need to enable the php_oci8.dll in your php.ini for php to have those functions included. make sure that have all the dll's are copied to the right place.

here is a snippet of my httpd.conf

LoadModule php4_module c:/php/sapi/php4apache.dll

AddType application/x-httpd-php .php4
AddType application/x-httpd-php .php
AddType application/x-httpd-php .phtml
AddType application/x-httpd-php .php3

Anon

You can't use SetEnv to set the Oracle variables. They have to be set in the system. Oracle can not get to the variable set for apache and it needs to access them too.

If you are using NT or 2000 go to the control panel, chose "System" and then "Environment" and set your variables. If win9x then set them in autoexec.bat and reboot.

Two other things:

The Oracle bin and lib directories MUST be in your path. So when you are setting the variables also update PATH to include "C:\Oracle\Ora816\bin;C:\Oracle\Ora816\lib".
You are only setting two Oracle vars, set ORACLE_BASE to the same value as ORACLE_HOME (not sure if that one does anything but Oracle says to set it so I always set it just in case) and ORACLE_SID to your SID. Also, make sure you have set up your tnsnames.ora file with correct values.

G'Luck,

Jack