ID: 46497 Comment by: lester at lsces dot co dot uk Reported By: andre dot gadonski at gmail dot com Status: Open Bug Type: InterBase related Operating System: FreeBSD PHP Version: 5.2.6 New Comment:
Without more information on this there is nothing we can do. We do not even know if the remote server is visible from outside PHP, and so there is insufficient data to find a fault, since there are no other reports of ibase_connect not working? Previous Comments: ------------------------------------------------------------------------ [2008-11-10 10:15:21] mapopa at gmail dot com i think you need to use pconnect ibase_pconnect() acts very much like ibase_connect() with two major differences. First, when connecting, the function will first try to find a (persistent) link that's already opened with the same parameters. If one is found, an identifier for it will be returned instead of opening a new connection. ------------------------------------------------------------------------ [2008-11-07 00:39:35] fel...@php.net I can't reproduce it on Linux. ------------------------------------------------------------------------ [2008-11-05 19:00:55] andre dot gadonski at gmail dot com Description: ------------ I'm using connect, the error had to be in the connect function and not in the query function. The interbase server is not on same computer as the script. The function connect should be get the connection from the previous persistent connection. Apache version: Apache 2.0 Handler Reproduce code: --------------- <?php $conn = ibase_connect(...); $sql = ibase_prepare($conn, 'SELECT * FROM USUARIO WHERE USU_SENHA = ? AND USU_COD = ?;'); $query = ibase_execute($sql, $param['pwd'], $param['usr']); $row = ibase_fetch_object($query); exit(var_dump($row)); ?> Actual result: -------------- object(stdClass)#3 (6) { ["USU_COD"]=> int(61) ["USU_NOME"]=> string(25) "ANDRE GADONSKI DE FREITAS" ["USU_CATEG"]=> int(0) ["USU_SENHA"]=> string(6) "xxxx" ["USU_LOGIN"]=> NULL ["USU_DOMINIO"]=> NULL } <br /> <b>Warning</b>: Unknown: Unable to complete network request to host "***some ip***". Error reading data from the connection. Bad file descriptor in <b>Unknown</b> on line <b>0</b><br /> ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=46497&edit=1