I am Connecting yii.1 with mssql
and written code to retrieve data from server, when i run the index it give error :
CDbConnection failed to open the DB connection: SQLSTATE[08001]: [Microsoft][ODBC Driver 11 for SQL Server]Unable to complete login process due to delay in opening server connection
in main.php
‘db’=>array(
// 'class'=>'application.components.MsSqlConnection',
'connectionString' => 'sqlsrv:Server=xyz\SQLSERVER2012;Database=zbc',
// 'emulatePrepare' => false,
'username' => 'pqr',
'password' => 'xyz',
'charset' => 'utf8',
'tablePrefix' => 'tbl',
),
in index.php
$conn = Yii::app()->db;
$command = $conn->createCommand("select * from tbl_user");
$dataReader =$command->query();
foreach ($dataReader as $row) {
echo ">".$row['username']."<br>";
Thanks in advance.