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.