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 !