Problems connecting to oracle dbase using PHP4.03

Anon

I\'ve been trying to connect to a remote oracle database using PHP4.03 for
WINNT and Apache 1.3, without success.

I get the following error message:

ORA-12203 TNS: Unable to connect to destination

I can successfully connect to the same remote database via Sqlplus and other applications.

Any suggestions ?

Sharon

Anon

how does ur OCILogon syntax look like ??
have u specified the third argument as SQL*Net alias ??

Anon

Ocilogon syntax:

$connection = ocilogon("scott", "tiger", "SRS");

I also tried:

$connection = ocilogon("scott", "tiger", "@SRS");

Still the same error message.

Anon

Did you check the tnsnames.ora file in the machine where you have installed oracle?
does it contain your machine's name?

Anon

why don't u find all "tns*.ora" on ur machine - where PHP & Oracle client are installed,
just make sure both tnsnames.ora (i.e in paths ORACLE_HOME/NETWORK/ADMIN and ORACLE_HOME/NET80/ADMIN) have valid entry for ur alias "SRS".....
if not just copy/paste from one to another the config.

Anon

Try this:
$cstring=\"(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.254.50)(PORT=1521)))(CONNECT_DATA=(SID=ORCL)))\";

$c1 = ocilogon(\"system\",\"manager\",$cstring);

Change your host of course...

Hope this helps... (Thanks to whoever posted this first!)

TTYL
Derrick

Anon

Now I am getting a ORA-12222 TNS:no such protocol adapter error.

Any thoughts?

Anon

I just change my so to linux, all the problem just went away

Anon

I have tried it with perl and it works fine so I guess it should it php assuming U have set all the path correctly

             my $user         =        "myuser";  
             my $password  =        "mypass"; 
                     my $Oracle_DBI_connect="dbi:Oracle:host=myhost;sid=mysid;port=1521";

             $dbh = DBI->connect($Oracle_DBI_connect, $user, $password,
                                 { RaiseError => 1, AutoCommit => 0 }  );

ranjith

Great! Threads are still alive after 1 year! well done!