PECL packages for Linux SQLSRV and PDO_SQLSRV drivers (4.0.7) are available now.
https://github.com/Microsoft/msphpsql/releases
Instalación
La extensión SQLSRV se activa añadiendo el fichero DLL apropiado al directorio de extensiones de PHP y la entrada correspondiente al fichero php.ini. La descarga de SQLSRV viene con 8 ficheros controladores, cuatro de ellos son para el soporte de PDO. Si se está ejecutando PHP (PHP 5.3) no seguro a nivel de hilos se ha de utilizar el fichero php_sqlsrv_53_nts.dll. (Se debería usar una versión no segura a nivel de hilos si se utiliza IIS como servidor web). Si se está ejecutando PHP seguro a nivel de hilos se ha de utilizar el fichero php_sqlsrv_53_ts.dll. De forma similar, para PHP 5.4, se ha de usar php_sqlsrv_54_nts.dll o php_sqlsrv_54_ts.dll, dependiendo de si la instalación de PHP no es segura a nivel de hilos o sí lo es, respectivamente.
La versión más reciente del controlador se puede descargar aquí: » Descarga de SQLSRV 4.0. Si se necesita soporte para PHP 5.2 y/o PHP compilado con VC6, se ha de usar la versión 2.0 del controlador: » Descarga de SQLSRV 2.0.
Para más información sobre los requerimientos de SQLSRV, ver » Requerimientos del Sistema para SQLSRV.
La extensión SQLSRV solamente es compatible con PHP corriendo sobre Windows. Desde la versión 4.0 la extensión SQLSRV solo es compatible con PHP 7.0 corriendo sobre Linux o Windows.
add a note
User Contributed Notes 9 notes
denny ¶
2 years ago
grant at seljax dot com ¶
1 year ago
Running PHP 7.2 on IIS 10, I had to use the IIS Web Platform Components wizard to install the Microsoft PHP drivers version 5.2 x64 to get this command to work. Manually installing 4.0 drivers did not work.
shastry dot sushruth at example dot com ¶
3 years ago
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
simon ¶
5 years ago
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
plfort ¶
4 years ago
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.
remove dot four dot english dot rk at ee39 dot words dot de ¶
2 years ago
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
michael dot endrizzi at gmail dot com ¶
4 years ago
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
yahya kayhani ¶
5 years ago
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
