我有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