cakephp - mssql connection string

Hariprasad

New Member
Hi,
I have to connect cakephp with mssql server. I have installed mssql in my system. how to specify the connection string?

I tried this:

Code:
 public $default = array(
        'datasource' => 'Database/Sqlserver',
        'persistent' => false,
        'host' => 'localhost\SQLEXPRESS',
        'login' => 'username',
        'password' => 'password',
        'database' => 'dbname',
        'prefix' => '',
        //'encoding' => 'utf8',
    );
But getting this error:

Code:
SQLSTATE[08001]:[Microsoft][SQL Server Native Client 10.0]SQL Server Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF].
Thank You
Hari
 
Top