1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Guide Install PDO SQLSRV drivers to XAMPP (PHP 7.0/7.1)

Discussion in 'Tips & Guides' started by Lautaro, May 14, 2017.

Thread Status:
Not open for further replies.
  1. Lautaro

    Lautaro Administrator Developer

    Install PDO SQLSRV drivers to XAMPP (PHP 7.0/7.1)
    By default XAMPP doesn't include the PDO SQLSRV drivers for PHP, this guide will show
    you the steps to install the drivers so you can connect your WebEngine website
    using PDO's sqlsrv driver.
    Requirements:
    XAMPP with PHP 7.0 or higher version.
    https://www.apachefriends.org/download.html

    Step 1
    Download and install Microsoft's ODBC drivers:
    https://www.microsoft.com/en-US/download/details.aspx?id=36434

    Step 2
    Download the SQLSRV drivers (7.0/7.1):
    https://github.com/Microsoft/msphpsql/releases

    Step 3
    Add the driver DLL to your PHP's extension folder, usually "C:\xampp\php\ext"

    Step 4
    Open PHP's configuration file "php.ini"

    xampp1.jpg

    Step 5
    Load the extension

    xampp2.jpg

    Step 6
    Restart the Apache server.


    Once you complete all the steps you will be able to connect your WebEngine website using the PDO Sqlsrv driver.
    If you have any issues during the process or have any questions please open a new thread in the General Support section.

    Credits:
    Jonathan Parent Lévesque @ http://stackoverflow.com/a/42010963/1565534

    Regards,
    Lautaro.
     
Thread Status:
Not open for further replies.

Share This Page