php – 使用PDO连接到Firebird 3的“远程接口拒绝的连接”

发布时间：2020-12-13 13:11:49 所属栏目：PHP教程来源：网络整理

导读：尝试下面的代码,但导致异常 – 远程接口拒绝SQLSTATE [HY000] [335544421]连接： try { $dbh = new PDO("firebird:dbname=localhost/3050:empty","SYSDBA","masterkey"); $dbh-setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION); $sth = $dbh-query('

尝试下面的代码,但导致异常 – 远程接口拒绝SQLSTATE [HY000] [335544421]连接：

try {
    $dbh = new PDO("firebird:dbname=localhost/3050:empty","SYSDBA","masterkey");
    $dbh->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);
    $sth = $dbh->query('SELECT idmspos,idmsqnt,cdmsval from svc$dms'); 
    $sth->setFetchMode(PDO::FETCH_ASSOC); 

    while($row = $sth->fetch()) {  
        echo $row['idmspos']." ".$row['idmsqnt']." ".$row['cdmsval']."<br>";  
    }

    $dbh = null;
}
catch(PDOException $e) {
    $dbh = null;
    echo $e->getMessage();
}

眼镜：

Linux 3.2.0-4-686-pae #1 SMP Debian 3.2.65-1+deb7u1 i686 GNU/Linux
PHP 5.6
php5-interbase
Firebird 3 from official site. Server is worked,can connect to him from local and remote machine.

找到firebird.conf,取消注释(如果使用fbclient 2.x)并更改以下参数以禁用WireCrypt并为旧版身份验证设置更高的优先级：

WireCrypt = Disabled
AuthServer = Legacy_Auth,Srp,Win_Sspi
AuthClient = Legacy_Auth,Win_Sspi

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!