Pliis help dong bro or sis,
Sudah hampir seminggu ini nyoba koneksi dengan MSSQL SERVER 2005
dengan set sbb:
‘db’=>array(
‘connectionString’ => ‘mssql:host=SQLSERVER;dbname=blog’,
‘username’ => ‘sa’,
‘password’ => ‘AQAQAQ’,
‘charset’ => ‘utf8’,
‘tablePrefix’ => ‘tbl_’,
),
muncul pesan error: CDbConnection failed to open the DB connection: SQLSTATE[HY000]: General error: 10007 ‘NAMES’ is not a recognized SET option. [10007] (severity 5) []
Terus aku nyari-nyari di om Google, katanya ada bug di file CDbConnection.php di line 326. Kemudian aku sudah tambahkan sintaks :
$driver=strtolower($pdo->getAttribute(PDO::ATTR_DRIVER_NAME));
if($driver!==‘sqlite’ && $driver!==‘mssql’)
eh muncul pesan error baru:
Error 500
Invalid argument supplied for foreach()
Please help master yii