Unofficial Microsoft SQL Server Driver for PHP (sqlsrv) unofficial PHP SQL Server driver

Source: Internet
Author: User
Tags sql server driver zip folder

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:

    1. All known memory leak and memory exception bugs has been fixed *
    2. Column names can contain Unicode cha Racters
    3. The newest of any of these ODBC drivers are selected, depending on what ' s installed:
      1. SQL Server Native Client 12.0  (hasn ' t been invented as of June 2014!)
      2. SQL Server Native Client 11.0  (SQL Server 2012 ODBC driver)
      3. SQL Server Native Client 10.0  (SQL Server 2008/R2 ODBC driver)
      4. SQL Native client  (SQL Server 2005 ODBC driver)
    4. 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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.