Urgent Help Needed About PHP + ORACLE 8i

Discussion in 'PHP' started by Younis Shahbaz, Jan 13, 2009.

  1. #1
    Hi,

    I have to convert an oracle 8i database to MySQL database through PHP.
    For this purpose I was installing PHP, MYSQL, ORACLE, APACHE on my pc.
    I have installed these things according to the given order:

    ORACLE 8i ENTERPRISE EDITION
    APACHE 2.2.11
    PHP 5.2.4
    MySQL 5.1.30


    I have correctly installed ORACLE, MYSQL, APACHE and PHP. But the problem arises in their connection with each other.
    PHP is working well on APACHE and MySQL databases can also be accessed through PHP but I am unable to access ORACLE database through PHP.
    However, I can access it through a client SQL PLUS with username SCOTT and password TIGER.

    I have gone through different tutorials and I came to conclusion that their is something to do with a file OCI.dll (of Oracle 10g according to http://php5-oracle.blogspot.com/2008/01/faq-php-525-and-setup-phpoci8dll-oracle.html)

    phpinfo() is showing oci8 module but when I type 'php.exe -m' in Command Prompt, first I get the error "The Procedure entry point OCIStmtPrepare2 could not be located in the dynamic library OCI.dll" and then it shows the error "PHP Warning: PHP Startup: Unable to load dynamic library 'C:\Program Files\PHP\ext\php_oci8.dll' - the specified procedure could not be found. in Unknown on line 0" and I can't find the module oci8 in the list their.

    I have following files in PHP\ext\ folder:
    php_mysql.dll
    php_oci8.dll
    oci.dll

    and APACHE\bin\ contains:
    iconv (dir)
    ab.exe
    ApacheMonitor.exe
    apr_dbd_odbc-1.dll
    apr_dbd_oracle-1.dll
    apr_dbd_pgsql-1.dll
    apr_dbd_sqlite3-1.dll
    apr_ldap-1.dll
    dbmmanage.pl
    htcacheclean.exe
    htdbm.exe
    htdigest.exe
    htpasswd.exe
    httpd.exe
    httxt2dbm.exe
    libapr-1.dll
    libapriconv-1.dll
    libaprutil-1.dll
    libhttpd.dll
    logresolve.exe
    oci.dll
    rotatelogs.exe
    wintty.exe
    zlib1.dll

    Now anyone please help me configure ORACLE with PHP. Pleaseeeeeeeeee.
    Waiting for reply.
     
    Younis Shahbaz, Jan 13, 2009 IP