I really need some help regarding this problem I am having.

I have php4 running as a cgi on a windows2000 box. The oracle database is on a remote site. I can log in to it via pl/sql+.

My problem is when I enable the oci8 extension in the php.ini file, the system is looking of the oracle dynamic link library, and gives an error that it cannot find it. This happens when the page is accessed. Php is really new to me, and I don't where I should start to look.

I went as far as reloading the Oracle client. Reinstalling PHP and it's extensions. Restarted the webserver.

The error still persists.

Thank you in advance for your help.

Jas.

    What exactly is the error you are receiving?

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

      The exact error on the server is:

      "unable to load dynamic library'./extensions/php_oci8.dll', the specified procedure could not be found."

      the extensions folder contains as php_oci8.dll

      Thanks,

      Jas.

        That error implies that the php_oci8.dll isn't begin found or is failing to load successfully. Once you get it to load, then you should be able to get Oracle database connectivity.

        In your PHP.INI, try changing the "extension_dir" entry from the default "./" to the directory with the extensions in it. For example:
        extension_dir = c:\php4\extensions

        Verify that the version of php_oci8.dll matches the version of PHP you are running. Mismatched versions (or versions complied with different settings) can cause an extension not to load.

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

          thanks everyone..I found the problem to be my AMD CPU..

            Too bad about the CPU... and quite strange. Once you've worked-out the hardware problems, you'll want to ensure that the LD_LIBRARY_PATH is set&exported. Typically, this is $ORACLE_HOME/lib -- if you're OFA-compliant, then it should look like

            "/u01/app/oracle/product/8.1.7/lib"

            If you fail to declare/export that variable, Oracle [and apps that access its libraries (e.g., the OCI)] gets "fussy."

            Good luck,
            Todd

              Michael,

              I made the changes per your suggestion. I an still having problems loading this dll.

              any other suggestions.

              Jas.

                Is this server Internet accessible? I'd be interested in seeing a phpinfo() of it.

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

                  Write a Reply...