How Can I Connect Mysql And Remote Mssql Database (Two Database)

ikizmert · November 7, 2013, 12:02pm

Hello,

How can i connect to two database, mysql and remote mssql.

How can I connection config file distinguish between and how can call connection.

Thank you…

Keith · November 7, 2013, 12:28pm

Follow all the steps in this wiki article.

chandrantwins · November 7, 2013, 4:43pm

Inside components array…

you can have like this

Here [size=2]id.phl.in is remote server and localhost is 127.0.0.1[/size]

[size=2]

[/size]

	'db'=&gt;array(


		'connectionString' =&gt; 'mysql:host=id.phl.in;dbname=wb_admin',


		'emulatePrepare' =&gt; true,

[size=2] [/size][size=2]‘username’ => ‘root’,[/size]

		'password' =&gt; '',


		'charset' =&gt; 'utf8',


	),


	'addressdb'=&gt;array(


		'connectionString' =&gt; 'mysql:host=127.0.0.1;dbname=address',


		'emulatePrepare' =&gt; true,


		'username' =&gt; 'root',


		'password' =&gt; '',


		'charset' =&gt; 'utf8',


		'class'   =&gt; 'CDbConnection'


	),

In you model

you have to override this method like this

public function getDbConnection()

{


	return Yii::app()-&gt;addressdb;


}

Then it will start to work cheers…