On Sat, 07 Feb 2004 23:49:40 +0100, "PIII450@HOME.NL"
<PIII450@HOME.NL> wrote:
[color=blue]
>On Sun, 08 Feb 2004 22:06:03 +0000, Andy Hassall <andy@andyh.co.uk>
>wrote:
>[color=green]
>>On Fri, 06 Feb 2004 20:27:14 +0100, "PIII450@HOME.NL" <PIII450@HOME.NL> wrote:
>>[color=darkred]
>>>I'ts Oracle 9i and php 4.3.3 and eventhough I didn't mention it the
>>>first time I did give them the list right as well. So maybe this
>>>little extra info can help.
>>>
>>>And only 1 home :)[/color]
>>
>> It's often best to trim everything down to basics when it starts Doing Weird
>>Things. The corrupted-looking message probably qualifies as weird.
>>
>> A checklist off the top of my head, if you post replies to each point at least
>>it'll show where you stand:
>>
>>(1) Environment:
>>
>> What's in PATH?
>>
>>echo $_ENV['PATH'];
>>
>> Where's your Oracle home?
>>
>>echo $_ENV['ORACLE_HOME'];
>>
>> Although this may well not be set, since you're not actually supposed to set
>>ORACLE_HOME under Windows, unlike under Unix. (Oracle stores various bits of
>>information in the registry instead).
>>
>> Others:
>>
>>echo $_ENV['TNS_ADMIN'];
>>echo $_ENV['NLS_LANG'];
>>
>>(2) Does sqlplus work from the command line?
>>
>> sqlplus username/password@database
>>
>> < do some stuff like select sysdate from dual >
>>
>>(3) Does sqlplus work from PHP?
>>
>><pre>
>><?php
>>$descriptorspec = array(
>> 0 => array("pipe", "r"),
>> 1 => array("pipe", "w"),
>> 2 => array("pipe", "w")
>>);
>>$process = proc_open("sqlplus test/test@dev92lnx", $descriptorspec, $pipes);
>>if (is_resource($process)) {
>> fwrite($pipes[0], "select sysdate from dual;\n");
>> fclose($pipes[0]);
>>
>> while(!feof($pipes[1])) {
>> echo fgets($pipes[1], 1024);
>> }
>> fclose($pipes[1]);
>> $return_value = proc_close($process);
>>
>> echo "command returned $return_value\n";
>>}
>>?>
>></pre>
>>
>>(4) What does a minimal OCI8 example do? (alter username/password/database as
>>necessary):
>>
>><pre>
>><?php
>>putenv("NLS_LANG=ENGLISH_UNITED KINGDOM.WE8ISO8859P1");
>>
>>if (!$conn = OCILogon("test","test","dev92lnx")) {
>> $err = OCIError();
>> die($err['message']);
>>}
>>
>>print "<hr>Server Version: " . OCIServerVersion($conn) . "<hr>";
>>
>>if (!$stmt = OCIParse($conn,"
>>select sysdate from dual
>>")) {
>> $err = OCIError();
>> die($err['message']);
>>}
>>
>>if (!OCIExecute($stmt)) {
>> $err = OCIError();
>> die($err['message']);
>>}
>>
>>while (OCIFetchInto($stmt, $row, OCI_ASSOC+OCI_RETURN_NULLS)) {
>> print_r($row);
>>}
>>
>>OCIFreeStatement($stmt);
>>OCILogoff($conn);
>>?>
>></pre>[/color]
>
>I'll give it a go tomorrow and tell you what happened :))
>
>Thanks so far.
>
>Roger[/color]
I found it :)) It all started with the $_ENV['PATH'] you suggested.
The above mentioned occurred on 2 machines. When I did the set in a
command windows the ora\bin was in the PATH. When I looked at the
$_ENV['PATH'] it wasn't. Don't ask me why but just restarting IIS and
loading php again didn't do the trick. A reboot of the server was
needed. Afterwards PHP and OCI worked on 1 of the machines :)) When I
took a closer look the second machine had a second ora home. Don't ask
me why but those idiots from Atos installed oracle twice. I added the
second ora\bin to the PATH, rebooted the machine and now this one is
working as well :))
Thanks for your help and the lesson learned? Always reboot M$
Windblows after installing or changing something.
