Re: what the php guys need to do

I'm CCing php-db again. Fred Silsbee wrote:

This worked:

sqlplus hr/hr@LMKIIIGD

so I tried: (didn't work)

if ($conn=oci_connect('hr', 'hr', '//localhost/LMKIIIGD'))

Excuse me repeating the example PHP code I gave earlier for this SQL*Plus case:

    Or if you connect like:

sqlplus hr/hrpwd@LMKIIIGDNSID

    then use

$c = oci_connect("hr", "hrpwd", "LMKIIIGDNSID"); Since you have a different password and SID, your code would be:

    $c = oci_connect("hr", "hr", "LMKIIIGD");

This assume Apache (or the PHP command line) has the same environment as SQL*Plus - your post didn't mention whether it does or not. Also, running

    <?php
    phpinfo();
    ?>

will show you where your php.ini file is. Edit php.ini and set display_errors=On for purposes of debugging (don't leave it on in production applications) Chris -- Email: christopher.jones@oracle.com Tel: +1 650 506 8630 Twitter: http://twitter.com/ghrd Free PHP Book: http://tinyurl.com/f8jad