Hi Claudio, 1) Check the version of FreeTDS on both systems. 2) Check the freetds.conf file for differences (use the sam TDS version) 3) Check that php is compiled using --with-mssql on both systems (--with-sybase will give you aliases to some mssql_( functions but not all) - Frank > Hi all! > > I've stepped into an annoying problem when trying to fetch the tuples > returned by a stored procedure in a MSSQL database from a PHP program > running in a Centos Linux server running PHP 4.4.4. > > The stored procedure returns an arbitrary number of tuples, and my code > is only working when the SP returns one row. > > The code I'm using, simplified, follows: > > $db_conn = mssql_connect ("server", "user", "passwd"); > mssql_select_db("db",$db_conn); > > $query = "Exec stored_procedure '$par1', '$par2'"; > $result = mssql_query ($query); > > while ($row = mssql_fetch_array ($result)) { > echo $row["COL1"]; > echo "<br/>"; > } > > If stored_procedure () returns only one row, the code executes without > any problem. However, if there are more than one rows to be returned, > the program not only blocks, but also eats all the server's memory. > > I've run this program also in Ubuntu with PHP 4.4, and it works without > any problem, so I'm thinking it may be either a configuration problem of > the centos server, or a bug in the PHP version. > > Do you have any hint to solve this? I would appreciate any advice. > > Thanks in advance, > > Claudio > > -- > Claudio Saavedra <claudio.saavedra@xxxxxxxxx> > --------------------------------------------------------------------- > La informacion contenida en esta transmision (y sus documentos > adjuntos), es confidencial y no puede ser usada o difundida por > personas distintas a su(s) destinatario(s). > El uso no autorizado de la informacion contenida en > esta transmision puede ser sancionado criminalmente de conformidad con > la ley chilena. Si ha recibido esta transmision por error, por favor > destruyala y notifique al remitente. Atendido que no existe > certidumbre que el presente mensaje no sera modificado como resultado > de su transmision por correo electronico, nuestra empresa, no sera > responsable si el contenido del mismo ha sido modificado". > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php