note 10535 added to Oracle functions

From: Date: Tue, 09 Jan 2001 18:04:50 +0000
Subject: note 10535 added to Oracle functions
Groups: php.notes 
Request: Send a blank email to php-notes+get-9519@lists.php.net to get a copy of this message
Hi, I have oracle 8 server in a hp-ux machine. Now I want to access this oracle server from my NT workstation, where I have installed Oracle 8 client and a web server. I have tried to set the environment varable in NT like the notes above describes. But it just doesn't work. here is my Tnsnames.ora under orant\Net80\Admin: ================================================ OV_NET.WORLD = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = my.unix_host_name.com)(PORT = 1521)) (CONNECT_DATA = (SID = openview)) ) ============================================== and here is the sqlnet log file: ================================================ Fatal NI connect error 12203, connecting to: (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle80)(ARGV0=oracle80ov_net)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')))(CONNECT_DATA=(SID=ov_net)(CID=(PROGRAM=C:\php\php.exe)(HOST=MY.NT_PC_NAME.com)(USER=my_name)))) VERSION INFORMATION: TNS for 32-bit Windows: Version 8.0.5.0.0 - Production Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 8.0.5.0.0 - Production Time: 09-JAN-01 18:50:04 Tracing not turned on. Tns error struct: nr err code: 12203 TNS-12203: TNS:unable to connect to destination ns main err code: 12560 TNS-12560: TNS:protocol adapter error ns secondary err code: 0 nt main err code: 530 TNS-00530: Protocol adapter error nt secondary err code: 0 nt OS err code: 0 =============================================== As you can see the host name in sqlnet.log is wrong. How can I tell php to use the correct service. Everything works just fine in unix. But how can I set the variable correct in NT? Any help or suggestion will be welcome. Best wishes! http://www.php.net/manual/ref.oracle.php

« previous php.notes (#9519) next »