ID: 10853
Updated by: andy
Reported By: [EMAIL PROTECTED]
Old Status: Feedback
Status: Closed
Bug Type: Sybase (dblib) related
Operating System: RH6.2
PHP Version: 4.0.4pl1
New Comment:
no feedback after 40 days.
Previous Comments:
------------------------------------------------------------------------
[2001-06-12 17:43:55] [EMAIL PROTECTED]
Could you try with server that is NOT behind firewall?
Does this happen then?
------------------------------------------------------------------------
[2001-05-14 11:54:38] [EMAIL PROTECTED]
When I use persistent connections to a MS Sql server that is behind a firewall, If I
refresh the page fast enough (about 10 refreshes per second) one of the connections
will be opened with problems. I'm using ADODB and the mssql extension. However I had
the same problem with the raw functions of php. This is the code:
Class Data_Mensajes {
function Load(&$objMensajesNegocio) {
$objMensajes = &$objMensajesNegocio;
include('/usr/local/apache/componentes/adodb/adodb.inc.php');
ADOLoadCode('mssql');
//Nos conectamos al servidor de BD
$con = &ADONewConnection();
if($con->PConnect("200.52.76.2","Mexmatch","qf3ae$+as","MexMatch")) {
$query= "Select * From Mensaje Where IDUsuarioPara = 'WERA'";
$result = $con->Execute($query);
$i=0;
while(!$result->EOF) {
//$objBusiness_Mensaje[$i] = new Business_Mensaje();
$objBusiness_Mensaje = new Business_Mensaje();
$objBusiness_Mensaje->setIDMensaje($result->fields[0]);
$objBusiness_Mensaje->setIDUsuarioDe($result->fields[1]);
$objBusiness_Mensaje->setIDUsuarioPara($result->fields[2]);
$objBusiness_Mensaje->setSubject($result->fields[3]);
$objBusiness_Mensaje->setCuerpo($result->fields[4]);
$objBusiness_Mensaje->setFecha($result->fields[5]);
$objMensajes->setMensajes($objBusiness_Mensaje);
$result->MoveNext();
$i++;
}
}
$result->Close();
$con->Close();
}
} // Fin de Clase Data_Mensajes
------------------------------------------------------------------------
Edit this bug report at http://bugs.php.net/?id=10853&edit=1
--
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
