PECL packages for Linux SQLSRV and PDO_SQLSRV drivers (4.0.7) are available now.
https://github.com/Microsoft/msphpsql/releases
The SQLSRV extension is enabled by adding appropriate DLL file to your PHP extension directory and the corresponding entry to the php.ini file. The SQLSRV download comes 8 driver files, four of which are for PDO support. If you are running non-thread-safe PHP (PHP 5.3), use the php_sqlsrv_53_nts.dll file. (You should use a non-thread-safe version if you are using IIS as your web server). If you are running thread-safe PHP, use the php_sqlsrv_53_ts.dll file. Similarly for PHP 5.4, use the php_sqlsrv_54_nts.dll or php_sqlsrv_54_ts.dll depending on whether your PHP installation is non-thread-safe or thread-safe.
The most recent version of the driver is available for download here: » SQLSRV 4.0 download. If you need support for PHP 5.2 and/or PHP compiled with VC6, use the 2.0 release of the driver: » SQLSRV 2.0 download.
For more information about SQLSRV requirements, see » SQLSRV System Requirements.
The SQLSRV extension is only compatible with PHP 5 running on Windows. Since version 4.0 the SQLSRV extension is compatilbe only with PHP 7.0 running on Linux or Windows.
PECL packages for Linux SQLSRV and PDO_SQLSRV drivers (4.0.7) are available now.
https://github.com/Microsoft/msphpsql/releases
PHP Warning: PHP Startup: Unable to load dynamic library '...\ext\php_sqlsrv_56_nts.dll' - %1 is not a valid Win32 application.
This error may occur if the Visual C++ runtime required by sqlsrv can not be found. In this case, "Visual C++ Redistributable for Visual Studio 2012 Update 4 (x86)" had to be installed for the x86 compiled PHP running on a x64 OS. For further investigations, have a look at Sysinternals Process Monitor.
Robert
Microsoft's PHP driver for SQL Server only runs with PHP 32-bit builds
For some reason the default DLL files given at microsoft's website did not work for me. The author of this link : http://robsphp.blogspot.co.uk/2012/06/unofficial-microsoft-sql-server-driver.html has compiled the same driver with different version of VC which worked for me. Just leaving a note for anyone who may be benefited
Error msg:
PHP Fatal error: Call to undefined function sqlsrv_connect()
Make sure you load BOTH dll's listed in the README:
extension=php_sqlsrv_56_ts.dll
extension=php_pdo_sqlsrv_56_ts.dll
The latest version of the driver is available here : http://www.microsoft.com/en-us/download/details.aspx?id=20098
This version supports PHP 5.5.
SQLSRV doesn't use mssql_connect - it is it's own extension, therefore to connect you'd use sqlsrv_connect:
http://www.php.net/manual/en/function.sqlsrv-connect.php
hi dear.
do step by step
1- un comment php_mssql.dll & php_pdo_mssql.dll in php.ini.template file(php directory in software install path)
2- Copy the ntwdblib.dll library from the php directory to the apache/bin directory.
3- Stop and start apache
4- test your mssql with phpinfo() function.
5- finish
Tech & Support by Yahya kayhani (IRAN-RASHT)
support@kws.ir
www.kws.ir