How to enable php_mssql.dll extension in xampp 1.8.x

Question

I'm using xampp-win32-1.8.3-1-VC11-installer and i enabled php_mssql.dll extension in php.ini by remove ;

I copy php_mssql.dll to xampp\php\ext
and ntwdblib.dll to xampp\apache\bin

i got 2 files above in old of xampp version.

But when i start my apache in xampp then i get

How to fix that thanks

Solution

It announced from php website http://php.net/manual/en/intro.mssql.php

These functions allow you to access MS SQL Server database.

This extension is not available anymore on Windows with PHP 5.3 or later.

SQLSRV, an alternative extension for MS SQL connectivity is available from Microsoft: » http://msdn.microsoft.com/en-us/sqlserver/ff657782.aspx.

Since XAMPP 1.8.0 its used PHP 5.4.4 and php_mssql.dll extension is not available anymore on windows with PHP 5.3 or later. So you can't use this library to your new XAMPP although you get it from your old XAMPP. You must use alternative extension to connect to MS SQL Server database like SQLSRV.

See also ::

• http://php.net/manual/en/intro.mssql.php
• http://stackoverflow.com/questions/7402713/how-to-get-mssql-work-with-php-5-3

Your php version from XAMPP 1.8.3 is PHP 5.5.15, so you must use "php_sqlsrv_55_nts.dll" or "php_sqlsrv_55_ts.dll". Those files can be downloaded from http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=20098`.

Note :: see also the information on Details section to help you choose file that you must download

This link about documentation to code with sqlsrv library http://php.net/manual/en/book.sqlsrv.php