|
|
Posted by Andy Hassall on 11/18/42 11:38
On 28 Jan 2006 09:15:01 -0800, "rtconner" <rtconner@gmail.com> wrote:
>I just installed Apache 1.3/PHP 5 on my Windows XP compy. It works
>fine. Now I want to get the interface to Oracle 9 installed.
>
>My computer has instant client 10 installed, I regularly use sqlplus
>and can connect to the Oracle DB with python without problem.
>
>I uncommented the 'extension=php_oci8.dll' line in php.ini. Now I
>recieve a "Fatal error: Call to undefined function oci_connect()" when
>I try to use php to connect to the oracle database.
>
>What is going on here? I don't understand what I did wrong.
If you did a straightforward installation then the usual thing to watch for is
that the Oracle software won't be accessible by the local service user that
Apache (and hence PHP runs as). Check the permissions on your Oracle directory
- your interactive user will be able to use it, as you're already using
sqlplus, but probably not the user Apache runs as. An alternative is to get
Apache to run under your user account by modifying the service, but make sure
you realise the possible security implications before doing that.
Also make sure that the Oracle home is on the PATH environment variable _as
seen by the Apache process_ - i.e. set as a global environment variable, not
just a user environment variable.
Were there any errors (either message boxes, or in the Windows Event Log) when
you started Apache that indicates that it couldn't load php_oci8.dll? Usually
these then leads to information about a problem with PHP loading the Oracle
client DLL due to the issues above.
--
Andy Hassall :: andy@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool
Navigation:
[Reply to this message]
|