#35149 [Opn->Fbk]: MSSQL functions incompatible with SQL Server 2005

ID: 35149 Updated by: vrana@php.net Reported By: lukasoz at bigpond dot net dot au -Status: Open +Status: Feedback Bug Type: Documentation problem Operating System: XP SP2, Server 2003, *nix PHP Version: Irrelevant New Comment: What should be documented then? Previous Comments: ------------------------------------------------------------------------ [2005-11-11 09:45:25] wez@php.net dblib should continue to work to talk to sql server (the network protocol hasn't changed enough to break this); it's only the dblib API that has been deprecated (for a long while now). pdo_odbc works with sql server 2005; I performed a decent amount of tests against the beta version using both the traditional and the newer "SQL Native Client" versions of the ODBC drivers. ------------------------------------------------------------------------ [2005-11-08 07:10:18] lukasoz at bigpond dot net dot au Description: ------------ Per the following link, DB Library based interfaces (ntwdblib.dll, FreeTDS) are deprecated in Server 2005: http://msdn.microsoft.com/data/mdac/default.aspx?pull=/library/en-us/dnmdac/html/data_mdacroadmap.asp SQL Server 2005 uses the new SQL Native Client (SQLNCLI) API. This *may* be compatible with pdo_odbc. If the above is indeed true, it would be nice if there were a warning on the MSSQL pages regarding SQL Server 2005 compatibility. Thanks for all the great code, and sorry to "bug" you ;-) ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=35149&edit=1