[thelist] PHP/Oracle Connect Problems....

Chris Ditty CDitty at email.usps.gov
Thu Mar 14 12:54:19 CST 2002


     Yup.  Been there.  The tnsnames.ora file exists.  I can connect to the
     database using sql+ with no problems.

     any other ideas?



______________________________ Reply Separator _________________________________
Subject: Re: [thelist] PHP/Oracle Connect Problems....
Author:  thelist-admin at lists.evolt.org at INTERNET
Date:    3/14/2002 1:34 PM


You've probably already seen:

   http://www.php.net/manual/en/ref.oracle.php

Check your tnsnames.ora file, make sure that C:\ORANT\NET80\ADMIN\tnsnames.ora
exists and that it has a mapping to mlocr.

Dean


Chris Ditty writes:

> Does anyone have a really simple connection script for connecting to
> oracle?  I had one a few years ago (literally) and have lost it.  I now
> need to try and connect again and can't.  Below is what I have tried.
>
> putenv("ORACLE_HOME=C:\ORANT");
> putenv("TNS_ADMIN=C:\ORANT\NET80\ADMIN"); putenv("ORACLE_SID=mlocr");
> $conn=ora_logon("mlocr_user at mlocr","password");
>
> This is the error that I get.
> Warning: Oracle: Connection Failed: ORA-12154: TNS:could not resolve
> service name in c:\program files\web_dev\apache\htdocs\mlocr\connect.php on
> line 6
>
> This is strange as I can connect via SQL+ with the same info.
>
> I have spent the last hour looking through online archives and haven't had
> any luck.
--
For unsubscribe and other options, including
the Tip Harvester and archive of thelist go to:
http://lists.evolt.org Workers of the Web, evolt !



More information about the thelist mailing list