你写全了试试:
$conn=OCIPLogon("username","password","(DESCRIPTION=(ADDRESS=(PROTOCOL =TCP)(HOST=xxx.xxx.xxx.xxx)(PORT = 1521))(CONNECT_DATA =(SERVICE_NAME=servicename)))
$conn=OCIPLogon("username","password","(DESCRIPTION=(ADDRESS=(PROTOCOL =TCP)(HOST=xxx.xxx.xxx.xxx)(PORT = 1521))(CONNECT_DATA =(SERVICE_NAME=servicename)))
通常为了安全考虑,web服务器和数据库服务器不会是同一台计算机的。这样的做法很正常,应该没有什么问题,多是你的程序中有问题。
每个文件在前面加一个require_once "inc/config.php";
要不要?
{ echo "SUCCESS ! Connected to database\n";
}else
{echo "Failed :-( Could not connect to database\n";}
Ora_Logoff($conn);
?>
说实话,现在在网上找到比较多的就是这种连法
但是我没有成功过
倒是< ? if ($conn=Ora_Logon("user","password")) 去掉了TNSNAME
能连到本地oracle数据库上,我肯定已经建了TNS用sqlplus也能连通
现在也是在win2000下