WebEngine's 6th Anniversary

On December 19th, 2018 we will be celebrating 6 years of WebEngine CMS!
The event is here!

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

Status
Not open for further replies.

Lautaro

Administrator
Developer
#1
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.
 
Status
Not open for further replies.
Top