[RESOLVED] Using PHP with Oracle

Aybabtu

Hey guys,

I am having a problem with getting PHP to interface with Oracle. I am using IIS for my server and I am running on Windows 2000. I uncommented the oracle lines like it said to do and now when I try to run a test page to connect to Oracle I am getting the following message.

"The procedure entry point OCILobClose could not be located in the dynamic link library OCI.dll"

And the I get the following error:

"PHP Warning: PHP Startup: Unable to load dynamic library 'C:\PHP\php_oci8.dll'
- The specified procedure could not be found.
in Unknown on line 0"

My PHP.ini file has the following for extensions:

extension_dir = C:\PHP

Can someone please help me with this or offer any insite?

Aybabtu.

And I did search the site by the way and everything I found seemed to deal with Apache web server and not IIS.

dunhamcd

did you find a solution to this? I am having a very similiar problem.

Aybabtu

Still no resoultion? I have tried everything that I can think of and I still can not get this to work.

Aybabtu

::Bump::

Is the no Guru that can help me with this problem?

Aybabtu.

Aybabtu

::Last Bump::

I am just about to give up on this but I would like to redo our company intranet using php and intergrating with our Oracle system. Can someone offer any insite?

Aybabtu

Well I found what the problem was and I thought I would share the solution. I kept gettin error that windows was unable to load PHP_OCI8.dll. I went into the Dependency Walker and found that two other DLL files were red. When I looked futher into the issue I found that the each of these DLL were unable to load parts of the library. I moved all of the PHP_* dll's into my extension directory and that solved one problem. I had a problem with the OCI.dll module not loading all of it's components. So I went into my ORA92 folder and did the dependency walker on the OCI.dll file there. There were no problems. So I copied the working OCI.dll and all of the other components into my C:\WINNT folder (This is my extensions path) and now everything works. Kind of. but that is for another post.

Hope this helps.

Aybabtu.

penguin_powered

Why use IIS? Even Microsoft doesn't use it. How do I know this? Cause I've gotten 401 and other errors on Microsoft and MSN webpages, and the error messages came from Apache webserver. Interesting, huh?! 😉