Yii Framework Forum: Urgent! Koneksi yii ke MSSQL SERVER gagal, Mohon dibantu - Yii Framework Forum

Jump to content

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

Urgent! Koneksi yii ke MSSQL SERVER gagal, Mohon dibantu Rate Topic: -----

#1 User is offline   anane 

  • Newbie
  • Yii
  • Group: Members
  • Posts: 2
  • Joined: 20-July 10

Posted 22 July 2010 - 03:25 AM

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
0

#2 User is offline   fastcrash 

  • Standard Member
  • PipPip
  • Yii
  • Group: Members
  • Posts: 245
  • Joined: 10-March 10
  • Location:South Jakarta

Posted 22 July 2010 - 11:14 PM

ehm, lebih baik lempar ke forum internasional aja bos, maklum newbie Posted Image
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 Posted Image
0

#3 User is offline   hening malam 

  • Junior Member
  • Pip
  • Yii
  • Group: Members
  • Posts: 41
  • Joined: 10-October 10

Posted 10 October 2010 - 09:40 AM

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',
),
The Night Has Come to Hold Us Young - SmP
0

Share this topic:


Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users