我怎么能在我的Windows 2008 Server 2008 R2的安装PDO_SQLSRV？

我试图用PDO连接到SQL Server数据库。我一直在用它挣扎了一点点现在我得到我的网页上这个严重的错误，我试图连接到SQL Server

致命错误：未捕获的异常“PDOException”有消息“SQLSTATE [IMSSP]：这个扩展需要的Microsoft SQL Server 2012本机客户端ODBC驱动程序与SQL Server进行通信。访问以下网址下载的Microsoft SQL Server 2012本机客户端ODBC驱动程序在x86： http://go.microsoft.com/fwlink/?LinkId=163712 “

我从下载的驱动http://www.microsoft.com/en-us/download/details.aspx?id=20098 （SQLSRV30.EXE）我已经放置在PHP安装在服务器上的ext目录这些驱动程序2008 R2服务器。

我也有在扩展名列表中的在php.ini文件末尾添加这两条线

extension=php_pdo_sqlsrv_53_nts.dll
extension=php_sqlsrv_53_nts.dll

我使用的PH PVersion 5.3.19服务器API CGI / FastCGI的线程安全禁用

我确实看到pdo_sqlsrv ，但我没有看到一个客户端API版本。

这样做还有什么我需要做的是能够使用PDO连接到了SQL databses远程服务器？我需要在远程服务器上安装任何东西？

这是我的PHP我管理部分截图

这是我的连接类

<?php

class connection {

    private $connString;
    private $userName;
    private $passCode;
    private $server;
    private $pdo;
    private $errorMessage;
    protected $lastQueryTime;
    protected $lastQuery;

    private $pdo_opt = array (
                            PDO::ATTR_ERRMODE            => PDO::ERRMODE_EXCEPTION,
                            PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
                            PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8"
                            );




    function __construct($dbName = DATABASE_NAME, $serverName = DATABASE_HOST){

        //sets credentials
        $this->setConnectionCredentials($dbName, $serverName);

        //start the connect
        $this->startConnection();

    }

    function startConnection(){


            $this->pdo = new PDO($this->connString, $this->userName, $this->passCode, $this->pdo_opt);

            if( ! $this->pdo){

                $this->errorMessage  = 'Failed to connect to database. Please try to refresh this page in 1 minute. ';
                $this->errorMessage .= 'However, if you continue to see this message please contact your system administrator.';
                echo $this->getError();
            }
    }


    //this will close the PDO connection
    public function endConnection(){

        $this->pdo = null;
    }

    //return a dataset with the results
    public function getDataSet($query, $data = NULL)
    {
        $start = microtime(true);
        $cmd = $this->pdo->prepare( $query );

        $cmd->execute($data);
        $ret = $cmd->fetchAll();
        //$cmd->closeCursor();
        $this->lastQueryTime = microtime(true) - $start;
        $this->lastQuery = $query;

        return $ret;
    }



    public function processQuery($query, $data = NULL)
    {
        $start = microtime(true);
               //$this->pdo->beginTransaction();


        $cmd = $this->pdo->prepare( $query );
        $ret = $cmd->execute($data);
               //$this->pdo->commit();
               //$cmd->closeCursor();
        $this->lastQueryTime = microtime(true) - $start;
        $this->lastQuery = $query;

        return $ret;
    }


    //return last insert id
    public function lastInsertId($name = NULL) {
        if(!$this->pdo) {
            return false;
        }

        return $this->pdo->lastInsertId($name);
    }



    public function getOneResult($query, $data = NULL){
        $cmd = $this->pdo->prepare( $query );
        $cmd->execute($data);

        return $cmd->fetchColumn();
    }

    public function getError(){
        if($this->errorMessage != '')
            return $this->errorMessage;
        else
            return true;  //no errors found

    }

    //this where you need to set new server credentials with a new case statment
    function setConnectionCredentials($dbName, $serv){

        switch($serv){


            //MS SQL server
            case 'SQLSERVER':
                $this->connString   = 'sqlsrv:server='.$serv.';database='.$dbName;
                $this->userName     = 'username';  
                $this->passCode     = 'password';  
            break;

            //the defaults are predefined in the APP_configuration file - DO NOT CHANGE THE DEFAULT
            default:
                $this->connString   = 'mysql:host='.DATABASE_HOST.';dbname='.DATABASE_NAME.';charset=utf8';
                $this->userName     = DATABASE_USERNAME;
                $this->passCode     = DATABASE_PASSWORD;
            break;

            }

    }


public function lastQueryTime() {
    if(!$this->lastQueryTime) {
        throw new Exception('no query has been executed yet');
    }
    return $this->lastQueryTime;
}

public function lastQuery() {
    if(!$this->lastQuery) {
        throw new Exception('no query has been executed yet');
    }
    return $this->lastQuery;
}



}



?>

这是我用我的类来拉数据集

<?php
include('connection.php');

$sql_db = new connection('databaseName','SQLSERVER');

$call_details = $sql_db->getDataSet('SELECT
                                    LocalUserId AS loginName,
                                    RemoteNumberCallId AS PhoneNumber,
                                    SUM(CallDurationSeconds + HoldDurationSeconds + LineDurationSeconds) AS totalTalk
                                    FROM dbo.CallDetail WHERE LocalUserId = \'blah\' AND RemoteNumberCallId = \'123456789\'
                                    GROUP BY LocalUserId, RemoteNumberCallId');


$call_details->endConnection();

?>

我甚至试过这个代码，所以我不会用我的课，我仍然得到同样的错误

 $ss = new PDO("sqlsrv:server=SQLSERVER; Database=databaseName", "userName", "Password");

Answer 1:

我已经取代了

extension=php_sqlsrv_53_nts.dll
extension=php_pdo_sqlsrv_53_nts.dll

同

extension=php_pdo_sqlsrv_53_nts_vc9.dll 
extension=php_sqlsrv_53_nts_vc9.dll

insted的使用SQLSRV30.EXE我用SQLSRV20.EXE这个工作。

@FreshPrinceOfSo感谢您的帮助:)

谢谢：）

Answer 2:

我个人安装的Windows Server 2008 R2和配置与PHP / SQL服务器。

下载VC9 86非线程的最新的稳定版本的.zip 安全从PHP下载
解压到你的PHP目录
下载Microsoft驱动程序3.0 PHP为SQL Server
解压到你的PHP目录\ext
写以下扩展到php.ini
[PHP_SQLSRV_54_NTS]

extension=php_sqlsrv_54_nts.dll

[PHP_PDO_SQLSRV_54_NTS]

extension=php_pdo_sqlsrv_54_nts.dll