Doc #51871 [Asn->Csd]: PHP 5.3 missing MSSQL extension, but no documentation

Edit report at http://bugs.php.net/bug.php?id=51871&edit=1 ID: 51871 Updated by: pajoye@php.net Reported by: jcoutcher at aktion dot com Summary: PHP 5.3 missing MSSQL extension, but no documentation -Status: Assigned +Status: Closed Type: Documentation Problem Package: Documentation problem Operating System: Windows PHP Version: 5.3.2 Assigned To: pajoye New Comment: Docs have been updated. As recommended alternative, SqlSrv is suggested (2.0 supports PDO too). Previous Comments: ------------------------------------------------------------------------ [2010-05-28 16:57:30] jcoutcher at aktion dot com I know that...it's just *nothing* was mentioned in the change log about some VC6 modules not being available. What I'm basically looking for is to have this added to the changelog, and maybe a mention about the VC9 and VC6 module issues on the download page. ------------------------------------------------------------------------ [2010-05-28 16:51:05] kalle@php.net Some extension simply aren't available using VC9 for now, if you wish to continue using the old and deprecated dblib then you should use the VC6 binaries of PHP which we still provide. Else talking to MSSQL from PHP from VC9 you must seek alternatives such as ODBC, PDO_MSSQL, PDO_ODBC, SQLSRV (from Microsoft). ------------------------------------------------------------------------ [2010-05-20 16:01:38] jcoutcher at aktion dot com Description: ------------ After upgrading from 5.2.13 to 5.3.2, the Apache site I upgraded failed to function. After reviewing the log files, I noticed that PHP couldn't access the php_mssql.dll extension. Lo and behold, it was removed from the 5.3 series! Yet, I see NO REFERENCE to this being done in the 5.3.2, 5.3.1 and 5.3.0 change logs. This is a pretty MAJOR change...especially for those people using the module! If you could, please add a note in the change logs stating it was removed, and the following text to the Windows download page to save people the nightmare I went through last night: --- If you are currently running PHP 5.2 and utilizing the php_mssql.dll (Microsoft SQL Server) extension, it has been removed from 5.3. This was due to the fact that PHP 5.3 is now compiled using the updated VC9 libraries, which no longer includes the ntwdblib library. Ntwdblib provided the connectivity layer used by the php_mssql.dll extension, and is severely outdated. If you require connectivity to Microsoft SQL Server, Microsoft has provided an extension that works on the Windows platform only: http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=ccdf728b-1ea0-48a8-a84a-5052214caad9 Please note that you will need to recode portions of your PHP script to utilize the new library, as it does not use the “mssql_” prefix on functions (it uses “sqlsrv_” as it’s prefix.) --- Thank you! ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/bug.php?id=51871&edit=1