Oracle, PHP5, Apache2, oci_connect fails but sql*plus works

From: Ruben Schoenefeld (Ruben.Schoenefeld_at_uni-oldenburg.de)
Date: 03/29/05 

Date: Tue, 29 Mar 2005 23:39:54 +0200

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi -

after I got sql*plus to work on my Linux box and I recompiled PHP 5 to include
the oracle instant client, I run into a weird problem:

I get 'ORA-01017: invalid username/password; logon denied' when using the same
combination of username/password and Oracle instance that works in sql*plus on
the same machine.

The PHP page finds the tnsnames.ora alright cause when I use a different name
that is not in there, it gives me an error that it couldn't be found, so I
don't think that the tnsnames.ora is the reason here.

I also tried all weird combination of upper and lowercase, which doesn't seem
to matter to sql*plus, so I figure it doesn't make a difference in PHP.

Has anybody in this newsgroup ever run into the same problem?

Thanks,
Ruben
- --
Ruben Schoenefeld, ICQ 1-971-310, http://support.uni-oldenburg.de/~ruben/
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)

iD8DBQFCScsuKxQwayh8oDERAptLAJ92I+rwAXK6FI1zLwwS45PEwviiwgCdE3rX
Gq7wZi2ed/PgFmszmZzDPj4=
=H25I
-----END PGP SIGNATURE-----