求教连接数据库问题，win8.1(X64)+IIS+php5.5.23+sqlserver2008R2(x64)

goodstuday 2015-04-18 09:20:13

本人新手刚学习PHP，遇到连接SQLSERVER2008R2数据库问题，环境win8.1(X64)+IIS8.5+php5.5.23+sqlserver2008R2(x64)
PHP文件能成功执行，但是执行phpinfo()并未发现sqlsrv，执行数据库连接后提示如下：
PHP Fatal error: Call to undefined function sqlsrv_connect() in E:\wwwroot\php.com\test\2.php on line 11
----------------代码如下---------------
<?php
$serverName = "(local)";
$uid ="sa";
$pwd = "mypwd123";

$connectionInfo = array("UID"=>$uid,"PWD"=>$pwd,"Database"=>"phpdb");

$conn = sqlsrv_connect( $serverName,$connectionInfo);
if( $conn == false)
{
echo "连接失败！";
die( print_r( sqlsrv_errors(), true));
}
?>
-------------------------------------------------------------------------
望高手指点迷津

php5.5.23 下载地址
http://windows.php.net/downloads/releases/php-5.5.24-nts-Win32-VC11-x64.zip

php_pdo_sqlsrv_55_nts.dll下载地址
The Microsoft Drivers 3.2 for PHP for SQL Server provide connectivity to Microsoft SQL Server from PHP applications
SQLSRV32.EXE
https://www.microsoft.com/en-us/download/details.aspx?id=20098
解压SQLSRV32.EXE后，拷贝php_pdo_sqlsrv_55_nts.dll和php_sqlsrv_55_nts.dll 到PHP安装目录ext
并且修改了php.ini的配置文件extension=php_sqlsrv_55_nts.dll
extension=php_pdo_sqlsrv_55_nts.dll
mssql.secure_connection = On

Microsoft ODBC Driver 11 for SQL Server - Windows
http://www.microsoft.com/zh-cn/download/confirmation.aspx?id=36434

...全文