Welcome to MSSQL Forum!
MSSQL Forum - Discussions about Microsoft SQL Server

You are currently viewing our community forums as a guest user. Sign up or
Having an account grants you additional privileges, such as creating and participating in discussions.

cakephp - mssql connection string

Discussion in 'General' started by Hariprasad, Jan 20, 2018.

  1. Hariprasad

    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 (text):
     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 (text):
    SQLSTATE[08001]:[Microsoft][SQL Server Native Client 10.0]SQL Server Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF].
    Thank You
    Hari
  2. Peter Schmitz

    Peter Schmitz Administrator Staff Member

Share This Page