Connection String Main.php

sergiotosi · February 20, 2014, 8:28am

what is the connection string in main.php for database access

Thanks

chandrantwins · February 20, 2014, 9:04am

Hi,

Default is db … you can check in config/main.php

check this





'db'=>array(

			'connectionString' => 'mysql:host=localhost;dbname=e-learning',

			'emulatePrepare' => true,

[size=2]			[/size][size=2]'username' => 'root',[/size]

			'password' => '',

			'charset' => 'utf8',

		),

sergiotosi · February 20, 2014, 9:55am

no good! this solution:

CDbConnection failed to open the DB connection: could not find driver

D:\Php\EasyPHP-5.3.6.0\www\yii\framework\gii\generators\model\ModelCode.php(60)

The my database is Microsoft access "prova.accdb" e non file mysql.

other solution?

sergiotosi · February 21, 2014, 8:19am

in my main.php the connection string

'db'=&gt;array(


		'connectionString' =&gt;

'Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\Php\EasyPHP-5.3.6.0\www\yiic\protected\data\WebFail.accdb;

Persist Security Info=False;’,

		'emulatePrepare' =&gt; true,


		'username' =&gt; 'root',


		'password' =&gt; '',


		'charset' =&gt; 'utf8',


	),

in model generator, after botton preview, message error table "apparecchi" does not exist

levanchien_info · February 24, 2014, 1:57am

Thank for share !

Agus_Rizwan · February 24, 2014, 8:33am

Good day

I have been trying to create my first web app for yii, but I am struggling to get the correct results.

Warning: YiiBase::include(C:\xampp\htdocs\yii\framework/web/CWebApplication.php) [function.YiiBase-include]: failed to open stream: No such file or directory in C:\xampp\htdocs\yii\framework\YiiBase.php on line 403

Warning: YiiBase::include() [function.include]: Failed opening ‘C:\xampp\htdocs\yii\framework/web/CWebApplication.php’ for inclusion (include_path=’.;C:\xampp\php\pear\’) in C:\xampp\htdocs\yii\framework\YiiBase.php on line 403

Fatal error: Class ‘CWebApplication’ not found in C:\xampp\htdocs\yii\framework\YiiBase.php on line 125

please help me…