connect to Oracle

[Anon]

I have a simple connect to Oracle, via the OCILogon. However, I always get this error message:

I try a simple connect to Oracle8i via the OCILogon function, but I always get the error message below:

Warning: _oci_open_server: Error while trying to retrieve text for error ORA-12154 in /usr/local/apache/htdocs/OIC.php on line 6
invalid

Below is my coding:

<pre>
<?
$DBconnect = OCILogon('user','pass','db');
if ($DBconnect) echo "connected";l
else echo "Can't establish connection";

?>
</pre>

anything wrong with my syntax above?

Thanks
Louis

[sgbalsekar]

hi,

do check the name of the local Oracle instance or the name of the entry in tnsnames.ora....if it is the same as $db contents...

this being an optional parameters, cud be skipped...

hope this solves u r query,

regs,
sachin balsekar.

[Anon]

Hi,

Actually I just install Oracle on my machine, and I am newbie to Oracle also. So, I think I have to add/edit some value in my tnsnames.ora. One question here, where can I check the "local Oracle instance"?

Thanks in advance.