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
