Bug #17765 Updated: MSSQL stored procedure related functions do not exist

ID: 17765 Updated by: sniper@php.net Reported By: xavier@nextdimensioninc.com -Status: Open +Status: Bogus Bug Type: MSSQL related Operating System: Solaris 2.8 PHP Version: 4.1.2 New Comment: This mssql_execute() function is only available with the mssql extension which is available only on win32. Check the sybase documentation: http://www.php.net/manual/en/ref.sybase.php (some of these seem to have mssql_* aliases) Previous Comments: ------------------------------------------------------------------------ [2002-06-14 15:32:39] xavier@nextdimensioninc.com Yes, as mentionned above, every other MSSQL function is available and working, this includes mssql_query, mssql_result, mssql_connect, mssql_num_rows and more. Only the functions related to stored procedure initialization, binding and execution are simply not present in PHP 4.1.2 on Unix. After additional reading on the mssql_execute mannual page on the main documentation, a user commented that the source code of PHP for these functions are aliases of the similar sybase functions, and PHP will behave differently on Unix than on Windows with these functions. PHP was compiled in the following way: ./configure --with-apache=/usr/local/download/apache-1.3.25/ --with-sybase=/usr/local/freetds --enable-trans-sid Apache was compiled with: ./configure --enable-module=ssl --activate-module=src/modules/php4/libphp4.la This is using PHP 4.1.2 and apache 1.3.24 on a solaris 2.8 netra box. I'm not sure what additional information you require... the problem, to be brief is simply that all stored procedure related functions for the mssql extension on unix do not exist on php4.1.2. ------------------------------------------------------------------------ [2002-06-14 15:22:50] sniper@php.net Not enough information was provided for us to be able to handle this bug. Please re-read the instructions at http://bugs.php.net/how-to-report.php If you can provide more information, feel free to add it to this bug and change the status back to "Open". Thank you for your interest in PHP. Just wondering..are the other functions available? And how did you compile PHP ? ------------------------------------------------------------------------ [2002-06-14 14:24:23] xavier@nextdimensioninc.com http://www.php.net/manual/en/function.mssql-execute.php This page defines mssql_execute(); as available since version 4.1.0 I am using version 4.1.2 and compiled PHP with FreeTDS, not as a DSO module but in the apache binary. All the mssql functions are working just fine (mssql_query, mssql_connect, mssql_num_rows, etc...) but mssql_init and mssql_execute report the following error: Fatal error: Call to undefined function: mssql_execute() in /usr/local/infonext/reports.php on line 55. This is very unfortunate as I compiled PHP in a very painful way on a production machine. Is there a workaround ? Has this problem been fixed yet ? the documentation seems to be inaccurate since it states: (PHP 4 >= 4.1.0) Thanks. Xavier Spriet. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=17765&edit=1