problems connecting to remote oracle database
| From: | phil at bolthole dot com | Date: | Sat, 30 Jun 2001 16:39:11 +0000 |
| Subject: | problems connecting to remote oracle database | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-9989@lists.php.net to get a copy of this message | ||
Hi folks,
I'm having difficulties getting php4 to connect to a remote oracle
database.
I have an entry in tnsnames.ora, along the lines of
shorthostname = (etc, etc)
and I can use "sqlplus user/name@shorthostname" to connect just fine, as
a regular user. Even without ORACLE_SID set, since I have it set in
tnsnames.ora for that entry
But when I try
ocilogin("user","name","shorthostname");
on a php page, I get a printout of oracle error 01017: authentication
failed.
The listener log on that oracle machine confirms that I am actually
attempting to connect. But no details on what's going wrong.
Any suggestions?