PHP , apache , oracle 8i and .....DR WAT

Anon

Hi there ,

Everything works fine until I want to connect to oracle (oracle is enabled)
and dr watson is giving me :

The application , , generated an aplication error. The error generated on 12/6/2000 @ time.

The exception generated in c0000005 at adress
00010005(<nosymbols>)

EventID 4097.

The php file is giving me :

Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

Apache/1.3.14 Server at 10.10.10.0 Port 80

Anybody who can help me please ?????

Anon

Make sure that you're using the latest version of PHP4, and [very important] Orcale client 8.1.6 - if you're using Oracle client 8.0.5 it won't work, period.

Anon

Hi Wayne
Can i know the exact reason why Oracle 8.0.5 will not work with PHP4?
Thanxs
Ravi

Anon

Hello Ravi ,

Like Wayne suggest me: I used the latest version of php and the oracle client and things are working fine .....
I see no reason why you cannot upgrade to the latest oracle client....

Rgds

Gerry

Anon

I'm not 100% sure of the exact reason, as I have compiled the OCI modules with the Oracle 8.0.5 c modules, and it still didn't work for me.

It's to do with the way that Oracle client accesses the tnsnames.ora file. If you are using PHP4 and Oracle 8.0.5 then you must be running the Oracle server locally because it does not appear to be able to read the tnsnames.ora file in any form what-so-ever. If however you use the Oracle 8.1.6 client you can of course have the Oracle server anywhere you like, as expected, because it is then perfectly capable of reading the tnsnames.ora file.

I may stand corrected, but I believe that this is a Windows platform problem, and I don't think that the same problem exists on Unix/Linux/Solaris platforms.

All I can really suggest is that if you're having problems with Oracle and PHP then change your Oracle client to 8.1.6 and the world will appear round again <g>

Hope this is of some use to some (probably less haired than before) people out there.

TTFN !
Wayne