CakePHP 2.x MSSQL 2008 Connect


CakePHP 2.x MSSQL 2008 Connect

我有CakePHP 2。x和PHP 5.4.3在我的Windows机器上(Windows 8,使用WAMP)。我必须连接到其他的mssql服务器,因为我需要一些数据从那里。我已经试过很多联系方式了,但是错误信息总是相同的:

Error: A Database connection using "Sqlserver" was missing or unable to connect. 
The database server returned this error: Selected driver is not enabled
Error: Sqlserver driver is NOT enabled

我的database.php配置:

public $urniki = array(
    'datasource' => 'Database/Sqlserver',
    'persistent' => false,
    'host' => 'somehost.com',
    'login' => 'user',
    'password' => 'pass',
    'database' => 'db',
    'prefix' => '',
    'encoding' => 'utf8',
);

知道怎么连接这个吗?

确保已经安装了PHP的SQLServer驱动程序,这一行位于PHP .ini

Extension=php_sqlsrv.dll

查看更多详细信息:http://www.iis.net/learn/application-frameworks/install-and-configure-php-on-iis/install-the-sql-server-driver-for-php