Re: problems connecting to remote oracle database
| From: | Anthony Carlos | Date: | Mon, 02 Jul 2001 14:53:55 +0000 |
| Subject: | Re: problems connecting to remote oracle database | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-10022@lists.php.net to get a copy of this message | ||
Phil,
Perhaps I'm being nit-picky, but shouldn't it be OCILogon("$user",
"$PASSWORD", "$connect_string"); ?
Anthony
> From: phil@bolthole.com
> Date: Sat, 30 Jun 2001 09:39:11 -0700
> To: php-db@lists.php.net
> Subject: [PHP-DB] problems connecting to remote oracle database
>
> 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?
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net
> For additional commands, e-mail: php-db-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net