Re: Apache+Php(Win NT) -> Oracle(Unix)

My Computer Envionment is the same as your. And I want to connect to Oracle 8i on another solaris machine. My Computer is Windows 2000 Server, PHP4: I use the following: ---------- putenv("ORACLE_SID=SUN88"); putenv("ORACLE_HOME=D:\Oracle\Ora81"); $handle = ora_plogon("SCOTT/TIGER@SUN88", "") or die; ---------- Browser reports me another error not the same as yours. Warning: Unable to connect to ORACLE (ORA-06401: NETCMN:Invalid Driver Indicator) I can't resolve this problem, can anyone helps me???? Thanks -------------------------------- Edward Wong E-Mail:wyuanzheng@21cn.com Phone: 86-21-63615261 * 207 iSpaceBank Group, Shanghai. -------------------------------- ----- Original Message ----- From: "Olivier Lepretre" <olivier.lepretre@afrilink.net> To: "Lanterki Vassilis" <LanterkiV@intrasoftnet.com> Cc: <php-db@lists.php.net> Sent: Thursday, June 29, 2000 4:26 PM 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 > > > > -- > > , , > > / \/ \ > > (/ 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 > > > > > -- > 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