Persistant Db Connection To Mssql Server

mangeshlad86 · December 23, 2013, 1:25pm

I want to connect to the MS-SQL Server with persistent connection… so that the temporary table created in the previous query could be used there after. does anyone know how to do it using config file …?

srini1987 · July 16, 2015, 4:30am

Add ‘persistent’=>true in config file.

‘db’ => array(

        'connectionString' =&gt; '',


        'username' =&gt; '',


        'password' =&gt; '',


        'charset' =&gt; 'utf8',


        'enableParamLogging' =&gt; true,


        'enableProfiling' =&gt; true,


        'persistent'=&gt;true


    ),

something like this.