Please help. I'm going maaddd trying to figure this out. I've pretty much read all of
the online docs and spend countless hours reading through the archives..
I'm running PHP4 and Apache on my Win95 computer. I'm trying to connect to a remote
I'm getting a "Warning: _oci_open_server: ORA-12203: TNS:unable to connect to
destination ..." error message. Yet I know the environment is ok because I can tnsping
the database name and I can connect using SQL Plus to the database.
Here's the php code:
$tns = "(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL =TCP)(HOST =
njnwkora15.db.pseg.com)(PORT = 1527))) (CONNECT_DATA = (SID =MDC6) ) )";
$connect=OCIPLogon("MDC","MDC",$tns) or die("It's not possible to connect");
$sql = "select * from district";
OCIExecute($result) or die("It's not possible to query");
$CC = OCIResult($result,1);
$CCNome = OCIResult($result,2);
echo('<TR><TD>' . $CC . '</TD><TD>' . $CCNome . '</TD></TR>');
I shouldn't need to declase $tns above but I've tried with and without it. I'm also
including the ORACLE_SID, ORACLE_HOME and TNS_ADMIN variables in the autoexec.bat so
that they are declared as of machine bootup. I also added them to the httpd.conf for
Apache configuration like this:
SetEnv ORACLE_SID MDC6
SetEnv ORACLE_HOME D:\PROGRA~1\ORAWIN95
SetEnv TNS_ADMIN D:\PROGRA~1\ORAWIN95\NET80\ADMIN
Please help.... Before I switch to ASP...