Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2001072

[PHP-DB] 'ORA-12203: TNS:unable to connect to destination' error From: Barry Prentiss (thebear <email protected>)
Date: 07/20/01

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");

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 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>