Connection to Oracle

wxdqz

New Member
Hi

I am having quite a lot trouble with connecting to Oracle with php 4.0.3pl1

I have a folloving lines in my code:

if ($conn = ora_logon($user, $pass )) {
print "Connection OK"; ....

and the code returns the following error:

Warning: Oracle: Connection Failed: Error while trying to retrieve text for error ORA-12154 in news_lib.inc on line 11

If I try to modify the code like following:

if ($conn = ora_logon($user."@"$TNS, $pass )) {
print "Connection OK"; ....

PHP, or Oracle will return following error:

Warning: Oracle: Connection Failed: Error while trying to retrieve text for error ORA-03121 in news_lib.inc on line 11

The DB and PHP are on different servers. There is tnsnames.ora configured in php server and I can connect with SQL Plus to the from the php server.

I think that it is Oracle 7 that is running on the db server. I just wondered should there be something else than oracle.dll's running in the php server side?

You would save my week磇f you someone can help me with this problem =)

Thanks

- ARi
 
Back
Top