Oracle 8.1.7 & NT 4.0

[sean1230]

Hi,

I am trying to make Oracle connections using php / NT 4.0 / IIS 4.0.

I am running php 4.0.6 (cgi) and have downloaded the .dll files in order to use oracle on windows. I then modified the php.ini file to use these php_oci8.dll & php_oracle.dll and changed the extension <DIR> to go to C:/PHP/extensions. I also copied the .dll files to the system32 <dir> but to no avail. any ideas ?

Sean

[Anon]

How about telling us what error message(s) you are getting? Including some sample code that is failing would also be a good idea.

-- Michael
Darkstreak Computing & Innovations
www.darkstreak.com

[sean1230]

Hi Michael,

First of all i'm get a dialog box saying that the .dll php_oci8.dll cannot be found.
I have installed the .dll files from the zip archive & I have tried many variations / file paths. I have alos tried to load the .dll file in the code before the script executes but still no luck. Any Ideas?

Sean

!------- code snippet

<?php
/ dl("php_oci8.dll"); /
PutEnv("ORACLE_SID=name"); //only if you have more than one sids
$conn = OCILogon("scott", "tiger");
OCICommit($conn);
OCILogOff($conn);
?>

!---- Php.ini file

; Directory in which the loadable extensions (modules) reside.
extension_dir = c:/PHP/extensions
;include_path = ".;c:\php\includes"
; Whether or not to enable the dl() function. The dl() function does NOT work
; properly in multithreaded servers, such as IIS or Zeus, and is automatically
; disabled on them.
enable_dl = On

extension=php_oci8.dll
;extension=php_openssl.dll
extension=php_oracle.dll

!-------- Browser Message
X-Powered-By: PHP/4.0.6 Content-type: text/html
Fatal error: Call to undefined function: ocilogon() in d:\Inetpub\wwwroot\test\sean\querystring\display1.php on line 4
PHP Warning: Unable to load dynamic library 'c:/PHP/extensions/php_oci8.dll' - in Unknown on line 0 PHP Warning: Unable to load dynamic library 'c:/PHP/extensions/php_oracle.dll' - in Unknown on line 0

[Anon]

First off, try adding c:\php4\dlls and c:\php4\extensions to your WinNT search path.

If that doesn't help, then comment out php_oci8.dll, and uncomment something like php_ctype.dll in your c:\winnt\php.ini. It is a less complex extension, so it should be easier to test with. Try using some of the ctype_*() functions to see if it can find that extension. Once you can get that extension to load, the same should be applied to the php_oci8.dll.

-- Michael
Darkstreak Computing & Innovations
www.darkstreak.com

[sean1230]

Thanks for your help Michael, I will try to what you suggested in the next few days and then let you know how it goes.

Sean

[Anon]

Sean,
It appears you have uncommented both of the oracle dlls in you php.ini.

extension=php_oci8.dll
;extension=php_openssl.dll
extension=php_oracle.dll

comment out the extension=php_oracle.dll as I have read having both loaded creates problems. I am having the same problem you are so if you find a solution would you mind letting me know. Thanks