AW: [PHP] Access to oracle db
| From: | Sebastian Stadtlich | Date: | Tue, 10 Jul 2001 15:30:33 +0000 |
| Subject: | AW: [PHP] Access to oracle db | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-57170@lists.php.net to get a copy of this message | ||
hi
did you specify the third 'optional' parameter?
OCILogon (string username, string password [, string db])
db should be your tnsname
on windows i could not make it without that parameter.
it should be set as enviroment variable ORACLE_SID,
but that did not work for me on win( it does on linux )
despite that no further configuration was needed by me after installing
the
oracle client
sebastian
> -----Ursprungliche Nachricht-----
> Von: giupar@sirmione.sodalia.it [mailto:giupar@sirmione.sodalia.it]Im
> Auftrag von Parisi Giuliano
> Gesendet: Dienstag, 10. Juli 2001 17:10
> An: php-general@lists.php.net
> Betreff: [PHP] Access to oracle db
>
>
> Hi,
> I've installed Apache server and PHP interpreter on Microsoft Windows
> platform. I'm trying to access to Oracle db without results (I've
> installed Oracle client and configured tnsnames.ora file). PHP
> interpreter return following error:
>
> Oracle: Connection Failed: ORA-12154: TNS:could not resolve
> service name
> in ...
>
> I think that Oracle client used by PHP doesn't find tnsnames.ora file
> (I've tryied to move tnsnames.ora file from installation folder to
> another folder and error message doesn't change).
> sqlplus utility, that used the same tnsnames.ora file,
> correctly access
> to oracle db without problem .
> The question is: how can I configure PHP to enable access to oracle db
> via oracle client ?
> Thanks in advantage for any suggestion.
> Regards
>
> Giuliano
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net
> For additional commands, e-mail: php-general-help@lists.php.net
> To contact the list administrators, e-mail:
> php-list-admin@lists.php.net
>