[thelist] PHP/Oracle Connect Problems....
Dean Mah
dmah at shaw.ca
Thu Mar 14 13:04:53 CST 2002
Do you have a global_names, or something like that, defined in your
sqlnet.ora file? Try appending that name to your service name. For
example, mlocr_user at mlocr.host.com.
I'm not a PHP programmer, but can you specify the connection as
mlocr_user/password at mlocr?
Dean
Chris Ditty writes:
> 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.
More information about the thelist
mailing list