問題描述

我使用的是通過 XAMPP 和 Microsoft SQL Server 2008 R2 (SQLEXPRESS) 安裝的 PHP 5.3.8 版.我已經正確安裝了驅動程序(我猜)并在 php.ini 中添加了正確的行(確切地說是 extension=php_pdo_sqlsrv_53_ts_vc9.dll).

我正在嘗試像這樣連接到服務器:

嘗試{$DBH = new PDO("mssql:host=xxxx;dbname=xxxx", 'xxxx', 'xxxx');} catch(PDOException $e) {echo $e->getMessage();}

我收到了找不到驅動程序"的錯誤消息，我已經對其進行了各種調整以解決該問題.我已經嘗試了所有其他類型的驅動程序，但這是唯一一個 Apache 在啟動時不給我錯誤的驅動程序.當我運行 phpinfo() 時，除了 pdo_sqlsrv.log_severity 設置為 0 之外，pdo_sqlsrv 字段都是空白的.

我從

I'm using PHP Version 5.3.8 that was installed via XAMPP along with Microsoft SQL Server 2008 R2 (SQLEXPRESS). I have the drivers installed correctly (i guess) and have added the correct line into php.ini (extension=php_pdo_sqlsrv_53_ts_vc9.dll to be exact).

I'm trying to connect to the server like so:

try {

    $DBH = new PDO("mssql:host=xxxx;dbname=xxxx", 'xxxx', 'xxxx');

} catch(PDOException $e) {

    echo $e->getMessage();
}

I get the "could not find driver" error, and I've tweaked it all kinds of ways to solve the problem. I've tried all other kinds of drivers, but this is the only one that Apache doesn't give me an error on startup. When I run phpinfo(), the pdo_sqlsrv fields are all blank except pdo_sqlsrv.log_severity which is set to 0.

I DL'd my drivers from microsoft, and I've tried both 2.0 and 3.0

Any advice would be awesome!!

mssql is the old way of doing it, sqlsrv should be more appropriate! In fact the extension is called (extension=php_pdo_sqlsrv_53_ts_vc9.dll) as well ;)

try {

    $DBH = new PDO("sqlsrv:Server=xxxx;Database=xxxx", 'xxxx', 'xxxx');

} catch (PDOException $e) {

    echo $e->getMessage();
}

Hope this helps!

Source : http://php.net/manual/fr/ref.pdo-sqlsrv.connection.php

這篇關于MSSQL PDO 找不到驅動程序的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網！