Page 1 of 1

How to run SQL Server (7.3) in Xampp

Posted: Tue 22 Jan 2019, 17:16
by Theet
If you are using Xampp en a SQL Server (Express) than you have to do the next steps, because Xampp is not supporting MSSQL by default.

Example PHP version = 7.3.0
1) Look at http://localhost/dashboard/phpinfo.php which version of PHP you are using, the driver should be the same version
2) Download from https://github.com/Microsoft/msphpsql/releases the same version of your PHP version 7.3.0
3) unzip the files and copy / past file php_pdo_sqlsrv_73_ts.dll and php_sqlsrv_73_ts.dll it into the folder C:\xampp\php\ext (from the x86 folder)
4) go to Xampp Control Panel and click on "Config" besides the Module Apache - open file php.ini
5) search for extension=
6) add:

Code: Select all

extension=php_sqlsrv_73_ts.dll
extension= php_pdo_sqlsrv_73_ts.dll
7) restart Apache
8) go again to http://localhost/dashboard/phpinfo.php and now you can see the pdo_sqlsrv version what is active.