#35704 [NEW]: function mssql-execute: stored procedure execution failed

From: frodriguez at isastur dot es Operating system: SuSe Linux PHP version: 5.1.1 PHP Bug Type: MSSQL related Bug description: function 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 -- Edit bug report at http://bugs.php.net/?id=35704&edit=1 -- Try a CVS snapshot (PHP 4.4): http://bugs.php.net/fix.php?id=35704&r=trysnapshot44 Try a CVS snapshot (PHP 5.1): http://bugs.php.net/fix.php?id=35704&r=trysnapshot51 Try a CVS snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=35704&r=trysnapshot60 Fixed in CVS: http://bugs.php.net/fix.php?id=35704&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=35704&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=35704&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=35704&r=needscript Try newer version: http://bugs.php.net/fix.php?id=35704&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=35704&r=support Expected behavior: http://bugs.php.net/fix.php?id=35704&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=35704&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=35704&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=35704&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=35704&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=35704&r=dst IIS Stability: http://bugs.php.net/fix.php?id=35704&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=35704&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=35704&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=35704&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=35704&r=mysqlcfg