Cakephp无法连接到sqlserver

Question

I got this error :

CakePHP is NOT able to connect to the database.

Database connection "Sqlserver" is missing, or could not be created.

Details :

• CakePHP 2.5.4
• Wamp server 32-bit
• Dreamweaver CS6
• SQL Server 2014

On my details.php

class DATABASE_CONFIG {

public $default = array(
    'datasource' => 'Database/Sqlserver',
    'persistent' => false,
    'host' => 'localhost\MSSQLSERVER',
    'database' => 'testing'
);

I have load both the extension on both ext folder (apache & php) and on php.ini

extension=php_sqlsrv_55_ts.dll
extension=php_pdo_sqlsrv_55_ts.dll

Searched everywhere but still cannot connect to sqlserver.

note : I can connect to MySQL but not SQLServer

Answer 1

In the end, i've found the solution. It's the problem of WAMPP server. Tho i have it installed on other machine and it works, it's not the same with the machine i'm currently using. So what i do is:

1. Uninstall WAMPP
2. Install XAMPP
3. Configure php.ini on apache and php
4. Load extensions in the ext folder of php

Note : I did the same configuration with WAMPP earlier

Then everything works like a charm.