Re: 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 > > -- > , , > / \/ \ > (/ file://_ \_ > .-._ \|| . \ > \ '-._ _,:__.-"/---\_ \ > ______/___ '. .--------------------'~-'--.)__( , )\ \ > '--.___ _\ / | ,' \)|\ > \| > /_.-' _\ \ _:,_ " || ( > .'__ _.' \'-/,-~ 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 >