远程服务器服务全启
本机TNSPING 结果 通
SQLPLUS直接上也可以
就是PHP连的时候怎么都连不上
OCI的连法空白
PDO_OCI的连就报无效句柄.....网上查都查不到怎么搞...晕了
oci的
<?PHP
class connect_orcale
{
public $c;
function connect_orcale($DBUSR,$DBPWD,$DBNAME)
{
$this->c=oci_connect($DBUSR,$DBPWD,$DBNAME);
//echo $this->c."1<br>";
}
}
?>
<?
class connect_orcale
{
public $c;
function connect_orcale($DBUSR,$DBPWD,$DBNAME)
{
try
{
$this->c= new PDO("oci:dbname=".$DBNAME,$DBUSR,$DBPWD);
} catch (PDOException $e) {
echo "Wrong message:" .$e->getMessage();
}
}
}
?>
报Wrong message:SQLSTATE[]: pdo_oci_handle_factory: OCI_INVALID_HANDLE (ext\pdo_oci\oci_driver.c:581)
唉... phpinfo里是这样的
oci8
----------------------------------------------------------
OCI8 Support enabled
----------------------------------------------------------
Version 1.2.4
Revision $Revision: 1.269.2.16.2.38 $
Active Persistent Connections 0
Active Connections 0
Temporary Lob support enabled
Collections support enabled
-----------------------------------------------------------------
------------------------------------------------------------------------------
Directive Local Value Master Value
------------------------------------------------------------------------------
oci8.default_prefetch 10 10
oci8.max_persistent -1 -1
oci8.old_oci_close_semantics 0 0
oci8.persistent_timeout -1 -1
oci8.ping_interval 60 60
oci8.privileged_connect On On
oci8.statement_cache_size 20 20
-----------------------------------------------------------------------------
PDO
-------------------------------------------------------------
PDO support enabled
--------------------------------------------------------------
PDO drivers oci
---------------------------------------------------------
PDO_OCI
--------------------------------------------------------------
PDO Driver for OCI 8 and later enabled
----------------------------------------------------------------