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

[Chris Ditty]

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.

Chris