LINUX, FreeTDS y ejecución de procedimientos almacenados

Nando
16 de Diciembre del 2005
Buenas os pongo el comentario que he puesto en php-bugs tal cual.
Creo que mi ingles es suficientemente malo como para que todo el mundo lo entienda.

Sistema Operativo; SuSe Linux
PHP version: 5.1.1
PHP Bug Type: MSSQL related
Bug description: funcion mssql-execute: stored procedure execution failed

Description:
------------
I have Apache, PHP 5.1.1 rebuilding with the mssql extension instead of the sybase extension and FreeTDS 0.63.

Note that the problem is in LINUX S.O. not in W2000 Server like in many other bug reports.

I try to execute a stored procedure site in a W2000 Server with SQL Server 2000 SP3.

The stored procedure haven\'t any parameter.

If I use mssql_query() work\'s correctly but if I use mssql_init() and mssql_execute the error take place.

The stored procedure do nothing, it\'s only for test purposes.

Thanks a lot.



Reproduce code:
---------------
echo "<BR>INICIANDO<BR>";
echo "<br>CONECTADO<br>";
$c = mssql_connect (\'XXX.XXX.XXX.XXX\', \'user\', \'pwd\');
if (mssql_select_db ("DATABASENAME", $c) == true)
{
//mssql_query("EXEC Test", $c);
$p = mssql_init("Test", $c);
$result = mssql_execute($p);
if (!$result)
{
$message = "Last message from SQL : " . mssql_get_last_message() . "";
echo $message;
}
else;
}
else;
echo "<br>FINALIZANDO<br>";

Expected result:
----------------
Execute the stored procedure "Test"

Actual result:
--------------
INICIANDO

CONECTADO<--

Warning: mssql_execute() [function.mssql-execute]: stored procedure execution failed in /usr/local/httpd/htdocs/FRF_Pruebas/PruebaExecute.php
on line 15
Ultimo mensaje desde SQL : Changed database context to \'DATABASENAME\'. FINALIZANDO