尝试下面的代码,但导致异常 – 远程接口拒绝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