Re: - Erreur TNS

TNS resolution fails (if it's going to) across networks & (most viciously) when there are 2 versions of Oracle doing battle, as both need their own 'orahome' filepath. . Isn't there the equivalent of a TNS hosts file? - & ps Markus is right, you're on the wrong list! ----- Original Message ----- From: "Christophe Chassagneux" <c.chassagneux@teamnet.fr> To: "php-gtk" <php-gtk@lists.php.net> Sent: Tuesday, July 31, 2001 4:45 PM Subject: Re: [PHP-GTK] [PHP-GTK-ORACLE] - Erreur TNS But i'm on NT...... and Oracle7 ----- Original Message ----- From: "Markus Fischer" <mfischer@guru.josefine.at> To: "Christophe Chassagneux" <c.chassagneux@teamnet.fr> Cc: "php-gtk" <php-gtk@lists.php.net>; <php-db@lists.php.net> Sent: Tuesday, July 31, 2001 3:27 PM Subject: Re: [PHP-GTK] [PHP-GTK-ORACLE] - Erreur TNS Such questions are best asked at php-db@lists.php.net . I've defined them in the envoironent throgh a shell script looking like this export ORACLE_BASE=/u01/app/oracle export ORACLE_HOME=/u01/app/oracle/product/8.1.7 export ORACLE_SID=home export PATH=/u01/app/oracle/product/8.1.7/bin:$PATH export CLASSPATH=.:/u01/app/oracle/product/8.1.7/jdbc/lib/classes111.zip export LD_LIBRARY_PATH=/u01/app/oracle/product/8.1.7/lib export ORA_NLS33=/u01/app/oracle/product/8.1.7/ocommon/nls/admin/data export NLS_LANG=german and I had no problems whatsoever to access oracle database within my php-gtk application. - Markus On Tue, Jul 31, 2001 at 04:06:16PM +0100, Christophe Chassagneux wrote : > I have a simple script in php : > > putenv("ORACLE_HOME=D:\\ORANT"); > putenv("TNS_ADMIN=D:\\ORANT\\NETWORK\\ADMIN"); > putenv("ORACLE_SID=xxxxxxxxx"); > > echo "Oracle : ". getenv("ORACLE_HOME")." \n"; > echo "TNS_ADMIN : ". getenv("TNS_ADMIN")." \n"; > echo "ORACLE_SID : ". getenv("ORACLE_SID")." \n"; > > $connect_oracle = ora_logon("xxxxx@xxxxxxx" , > "SERETI" ); > > But then i do : > e:\> php testoracle.php > the prog reply : ORA-12154 : TNS name not resolved > > with apache server, I don't have this problem. > Can u help me ? > > > > -- Markus Fischer, http://guru.josefine.at/~mfischer/ EMail: mfischer@guru.josefine.at PGP Public Key: http://guru.josefine.at/~mfischer/C2272BD0.asc PGP Fingerprint: D3B0 DD4F E12B F911 3CE1 C2B5 D674 B445 C227 2BD0 -- PHP GTK Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-gtk-unsubscribe@lists.php.net For additional commands, e-mail: php-gtk-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net -- PHP GTK Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-gtk-unsubscribe@lists.php.net For additional commands, e-mail: php-gtk-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net