[anane]

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

[fastcrash]

ehm, lebih baik lempar ke forum internasional aja bos, maklum newbie
soalnya belum punya experience dgn mssql.

kyanya saya pernah lihat threadnya deh..
search title only : mssql

mssql-driver

MSSQL on IIS connection problem

oh ya coba update k versi terbaru.
semoga membantu

[hening malam]

coba di koment bagian charset utf 8 btw ini setting yg aku pake

'db'=>array(
'connectionString' => 'dblib:host=bluejune;dbname=rsjune',
//'emulatePrepare' => true,
'username' => 'yyy',
'password' => 'xxx',
//'charset' => 'utf8',
),