RE: [PHP-DB] Apache+Php(Win NT) -> Oracle(Unix)
| From: | Lanterki Vassilis | Date: | Thu, 29 Jun 2000 08:50:40 +0000 |
| Subject: | RE: [PHP-DB] Apache+Php(Win NT) -> Oracle(Unix) | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-740@lists.php.net to get a copy of this message | ||
The DB alias is defined in tnsnames.ora.
The listened must be up cause the "plus80 user/passwd@DBNAME" to the
specific DB works juuuust fine.
anything else i can try???
-----Original Message-----
From: Olivier Lepretre [mailto:olivier.lepretre@afrilink.net]
Sent: Thursday, June 29, 2000 11:27 AM
To: Lanterki Vassilis
Cc: php-db@lists.php.net
Subject: Re: [PHP-DB] Apache+Php(Win NT) -> Oracle(Unix)
Hi :
In your tnsnames.ora, is your DB alias defined ?
Is your Listener started on unix ?? (lnsrctl ???)
Under a command bloc, just try plus80 user/passwd@DBNAME
If it doesn't work, define the ORACLE_SID variable and set it to your DBANME
----- Original Message -----
From: "Lanterki Vassilis" <LanterkiV@intrasoftnet.com>
To: "Php-DB List" <php-db@lists.php.net>
Sent: Thursday, June 29, 2000 10:23 AM
Subject: [PHP-DB] Apache+Php(Win NT) -> Oracle(Unix)
> <code>
> $cnx = ocilogon('wdba', 'wdba', 'nomos1_law');
> $cur = ociparse($cnx, "select count(*) from n_dd_appusers");
> ociexecute($cur);
> echo ociresult($cur, 1);
> ocilogoff($cnx);
> </code>
> I try to execute this code and all it gives me is this:
> Warning: _oci_open_server: ORA-12154: TNS:could not resolve service
> name
>
> I have set the "ORACLE_HOME" environment variable to "C:\ORANT"
> and the "TNSNAMES.ORA" file is located under the "C:\ORANT\NET80\ADMIN"
> folder
>
> I am using Apache 1.3.12 with PHP v4.0 on WinNT Workstation v4 SP6a and
> i am trying to connect to a Oracle8 v8.0.5.1.0
>
> with SQL*Plus: Release 8.0.5.0.0 connect just fine.
>
> any ideas??????
>
> TIA
>
> --
> , ,
> / \/ \
> (/ //_ \_
> .-._ \|| . \
> \ '-._ _,:__.-"/---\_ \
> ______/___ '. .--------------------'~-'--.)__( , )\ \
>
'--.___ _\ / | ,' \)|\
> \|
> /_.-' _\ \ _:,_ " || (
> .'__ _.' \'-/,-~ LanterkiV@intrasoftnet.com
> |/
> '. ___.> /=,| |
> / .-'/_ ) | |
> snd )' ( /(/ '---------------------------------'
> \\ "
> '=='
>
>
> --
> 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
>