Re: 'ORA-12203: TNS:unable to connect to destination' error

Solved! Thx Stathis, but it wasn't OciLogon("user","pass",'SLAC'), but OciLogon("user","pass",'SLAC_TCP'). i.e. not the SID but the TWO_TASK variable it was after... Thx Again, Barry "Rouvas Stathis" <rouvas@di.uoa.gr> wrote in message news:3B58711A.EECDF435@di.uoa.gr... > Barry Prentiss wrote: > > > > Hi All, > > I finally got past the php_oci8.dll problem by moving it to the same > > directory as php.exe and changing the php.ini extensions_dir back to './'. > > > > Now I am getting the following error: > > > > Warning: _oci_open_server: ORA-12203: TNS:unable to connect to > > destination in c:\program files\apache > > group\apache\htdocs\dna\dna_oci_sys_list.php on line 20 > > > > which occurs at the $conn line below: > > > > error_reporting (E_ALL); > > putenv('ORACLE_HOME=C:\orant'); > > putenv('TNS_ADMIN=C:\orant\NET80\ADMIN'); > > putenv('ORACLE_SID=SLAC'); > > putenv('TWO_TASK=SLAC_TCP'); > > > > $conn = ociLogon("user","password"); > > Try, OciLogon("user","pass",'SLAC'). What do you get? > > -Stathis. > > > > > This implies that I am reaching the Net8 oci client libraries (right?). > > > > My environment: PHP 4.0.5, Apache 1.3.19, W2K, Net8 8.0.6.0.0, remote Oracle > > 8.1.6 on Solaris. > > > > I can connect through SQL*Plus, tests OK through Net8 assistant, > > tnsnames.ora is in proper place (as defined in TNS_ADMIN above). > > > > What am I doing wrong? > > Thx in advance, > > Barry Prentiss