Original unofficial Microsoft SQL Server Driver for PHP (sqlsrv)
Here is unofficial modified builds of Microsoft ' s sqlsrv and pdo_sqlsrv drivers for PHP, version 3.0, for:
- PHP 5.6 for Windows vista/2008 and above (+ +)
- PHP 5.5 for Windows vista/2008 and above (+ +)
- PHP 5.3 and 5.4 for Windows xp/2003 and above
Microsoft's version 3.0 driver does not run on xp/2003 because it had a hard-coded dependency on the SQL Server (s) Nativ E Client (ODBC driver), which won't install on XP. To fix the problem I just had to allow the PHP driver to use a older version of the ODBC driver supported by XP.
Downloads
- php_sqlsrv_3.0.2.2 for PHP 5.6, 5.5, 5.4 and 5.3 (June, PHP 5.6 added August 2014)
The builds is in the Zip folder 'x64'.
- Previous versions is in a folder on my onedrive:previous versions
The latest drivers is exactly the same as Microsoft ' s, except:
- All known memory leak and memory exception bugs has been fixed *
- Column names can contain Unicode cha Racters
- The newest of any of these ODBC drivers are selected, depending on what ' s installed:
- SQL Server Native Client 12.0 (hasn ' t been invented as of June 2014!)
- SQL Server Native Client 11.0 (SQL Server 2012 ODBC driver)
- SQL Server Native Client 10.0 (SQL Server 2008/R2 ODBC driver)
- SQL Native client (SQL Server 2005 ODBC driver)
- versions included for PHP 5.5 and 5.6
Builds for PHP 5.3 and PHP 5.4 work on XP and above.
Builds for PHP 5.5+-on Windows vista/2008 and above-php 5.5+ are built with the-the-one compiler and of Visual C + + It generates code that works on Windows Vista and above. I am comfortable with THAT-XP have been superseded a long time ago, Windows 8.1 is absolutely great, and don ' t forget tha T upgrading Windows also upgrades to a far better Web server in IIS 7.5 or 8.5.
It's never a good idea-to-look on the source code of things you like-since I had-look, my new list of things to does in Cludes writing a new version of this driver. It is a wrapper around the ODBC API, and have no business making strict dependencies on any version of the SQL Server Nativ E-Client. It should even work with SQL Server 6, because there is a ODBC driver for that too. Furthermore, it's a pretty ugly bit of code and every update is likely to introduce new bugs. It's still a better choice than using the PHP ODBC driver, as it ' s much faster in returning data, it's multilingual (ncha R and nvarchar), it supports the majority of data types, and includes parameters.
* SQLSRV Changes
The sqlsrv driver have a fix to a bug found by Charles Durrant (http://sqlsrvphp.codeplex.com/workitem/22427) which I too recently experienced when running PHP-32 on a the bit server. I noted Charles ' s post when he first reported the bug, but tried my best to avoid working on the source code until I had t O... Charles saved me a huge amount of time, so thank to him. My fix is different, I has repaired all of Microsoft's dodgy auto pointers and completely rewritten the horrible function That caused the crash. If anyone uses these new builds and spots memory leaks or bugs due to these changes, please let me know and I ll fix them Within a day or both.
Microsoft ' s official downloads is here:
- http://www.microsoft.com/en-us/download/details.aspx?id=20098
SQL Server Native clients is here:
- SQL 2012
http://www.microsoft.com/download/en/details.aspx?id=29065
- SQL R2
http://www.microsoft.com/download/en/details.aspx?id=16978
- SQL 2005
Http://www.microsoft.com/download/en/details.aspx?id=20101
Unofficial Microsoft SQL Server Driver for PHP (sqlsrv) unofficial PHP SQL Server driver