#35704 [Opn->Asn]: function mssql-execute: stored procedure execution failed

ID: 35704 Updated by: tony2001@php.net Reported By: frodriguez at isastur dot es -Status: Open +Status: Assigned Bug Type: MSSQL related Operating System: SuSe Linux PHP Version: 5.1.1 -Assigned To: +Assigned To: fmk New Comment: assigned to the maintainer. Previous Comments: ------------------------------------------------------------------------ [2005-12-16 11:00:23] frodriguez at isastur dot es 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 ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=35704&edit=1