Re: [PHP-DB] Remote Oracle Connection

2001-02-05 Thread Steve Farmer
Hi Doug, This works for me.. putenv("ORACLE_SID=MYINSTANCE"); $uid = "MYUSERID"; $pwd = "MYUSERPASSWD"; $inst = "MYINSTANCE"; $conn = ocilogon($uid,$pwd,"$inst"); if(!$conn): echo "unable to connect to database"; ocilogoff($conn); endif; $query= "alter session set NLS_DATE_FORMAT = 'DD-MON-Y

[PHP-DB] Remote Oracle Connection

2001-02-04 Thread Doug Schasteen
Am I blind? Or is there no support with the regular oracle functions to connect to a database that is hosted on another machine? The manual has this: $conn = Ora_Logon(username, password); but I don't see anywhere to put the host string. - Doug Schasteen