PHP 5.4与MS SQL server 2008 r2的连接

Question

我想连接到本地主机上现有的MS-SQL数据库，我已经安装了MS-SQL驱动程序3.0并编辑了php.ini以启用扩展，即

 extension=php_sqlsrv_54_ts.dll

我已经安装了native client 10.0，并收到以下错误：

array (size=2)
  0 => 
    array (size=6)
      0 => string 'IMSSP' (length=5)
      'SQLSTATE' => string 'IMSSP' (length=5)
      1 => int -49
      'code' => int -49
      2 => string 'This extension requires the Microsoft SQL Server 2012 Native Client. Access the following URL to download the Microsoft SQL Server 2012 Native Client ODBC driver for x86: http://go.microsoft.com/fwlink/?LinkId=163712' (length=216)
      'message' => string 'This extension requires the Microsoft SQL Server 2012 Native Client. Access the following URL to download the Microsoft SQL Server 2012 Native Client ODBC driver for x86: http://go.microsoft.com/fwlink/?LinkId=163712' (length=216)

如果我尝试安装Microsoft SQL Server 2012 Native Client，错误是操作系统不受支持。

服务器正在运行MS Server2008 R2、MS-SQL2008 R2和Apache2.4.4

Answer 1

从错误消息看，您似乎需要从以下位置下载并安装"Microsoft SQL Server 2012 Native Client ODBC driver for x86“：

http://www.sqlservercentral.com/Forums/Topic1458276-2799-1.aspx

确保获得适用于您的操作系统的正确版本的Native Client

该页面提供了让MSQL为您工作的所有链接。