Error trying to use php_oci8.dll

[mike]

I get the following line when trying to uncomment the
extension=php_oci8.dll line in my php.ini file.
-------------------------------------------------

PHP Warning: Unknown(): Unable to load dynamic library
'c:\php\extensions\php_oci8.dll' - The specified procedure could not
be found. in Unknown on line 0

-------------------------------------------------

I've verified that the path to ORACLE_HOME is in my path statement.
I've verified that I have the latest MDAC. I've also verified that I
have the extension_dir line set correctly ( "c:\php\extensions" )

I can get the php_oracle.dll to work just fine but not the
php_oci8.dll

I'm running IIS server on Win2K professional. Php works fine for
everything I've tried except this.

I'm using the latest stable release of php.

my oracle installation is 8.1.6 which is kind of old but php.net says
oci8 should work with oracle 7 or better.

Any help would be greatly appreciated.

[Andy Hassall]

On 20 May 2004 13:22:05 -0700, si*********@hotmail.com (mike) wrote:

I get the following line when trying to uncomment the
extension=php_oci8.dll line in my php.ini file.
-------------------------------------------------

PHP Warning: Unknown(): Unable to load dynamic library
'c:\php\extensions\php_oci8.dll' - The specified procedure could not
be found. in Unknown on line 0

-------------------------------------------------

I've verified that the path to ORACLE_HOME is in my path statement.
Should be ORACLE_HOME/bin, not just the path to ORACLE_HOME.
I've verified that I have the latest MDAC.
Not required - doesn't use it.
I've also verified that I
have the extension_dir line set correctly ( "c:\php\extensions" )

I can get the php_oracle.dll to work just fine but not the
php_oci8.dll

I'm running IIS server on Win2K professional. Php works fine for
everything I've tried except this.

I'm using the latest stable release of php.

my oracle installation is 8.1.6 which is kind of old but php.net says
oci8 should work with oracle 7 or better.
Any reason why you have to stick with this desupported version? I've never run
8.1.6 with PHP, but I know for a fact 8i (8.1.7), 9i (9.2) and 10g (10.1) all
work well, and they're all supported versions of Oracle (although 8i dies at
the end of the year).
Any help would be greatly appreciated.

Does the IIS user have permission to load the OCI DLL? By this I'm referring
to the DLLs in the Oracle home, not just the PHP extension.

(Although from what I recall, 8i installs with fairly lenient permissions on
the ORACLE_HOME; in 9i it's stricter, and you definitely have to grant
permissions to the web server user for it to be able to start).

And anyway - it's saying 'procedure not found' - hm - I have a vague
recollection of a similar thing happening in Perl's Oracle driver, as 8.1.6 is
missing functions relating to LOBs that are present in 8.1.7. Would have to
look it up though.

Anything in the windows Event Log? Might be a more detailed description there
- maybe.

--
Andy Hassall <an**@andyh.co.uk> / Space: disk usage analysis tool
http://www.andyh.co.uk / http://www.andyhsoftware.co.uk/space