php 通过sqlsrv扩展连接sqlsver

简介:

The SQLSRV extension allows you to access Microsoft SQL Server and SQL Azure databases. The 3.0 release of the driver supports SQL Server, beginning with SQL Server 2005,
including SQL Server 2012 and SQL Server 2012 LocalDB. (For more information about LocalDB, see » PHP Driver for SQL Server Support for LocalDB and » SQL Server 2012 Express
LocalDB.) 翻译: SQLSRV扩展允许您访问Microsoft SQL Server和SQL Azure数据库。该驱动程序的3.0版本支持SQL Server,从SQL Server 2005开始,包括SQL Server 2012和SQL Server 2012 LocalDB。
(有关LocalDB的更多信息,请参见“支持LocalDB的SQL Server的PHP驱动程序”和“SQL Server 2012 Express LocalDB”。

参考文档:https://www.php.net/manual/zh/intro.sqlsrv.php

 

下载安装sqlsrv扩展

  1)下载地址:https://www.microsoft.com/en-us/download/details.aspx?id=20098    选择对应的php版本与操作系统版本

  2):在php.ini文件中配置

extension=php_sqlsrv_54_ts.dll
extension=php_pdo_sqlsrv_54_ts.dll

 3)通过phpinfo查看是否安装成功

 4)除了安装sqlsrv扩展外,sqlserver还需要安装Microsoft ODBC Driver For SQL Server 驱动

 请根据对应错误提示安装:  https://www.microsoft.com/zh-CN/download/details.aspx?id=36434

  

原文地址:https://www.cnblogs.com/fogwang/p/12501849.html