Connect Codeigniter with SQL Server 2012

[Steps 1]. Download File2 yang diperlukan for x64 :
1. xampp-win32-1.8.1-VC9-installer.exe ( Install Apache v2.4 & PHP v5.4 )
2. vcredist_x64.exe ( Visual C++ Redistributed for x64 )
3. SQLSRV30_PHP_CONNECTION.EXE ( Microsoft Drivers for PHP for SQL Server )
4. sqlncli_2012_x64.msi ( SQLSERVER NATIVE CLIENT 2012 )

[Steps 2]. Setelah proses installasi [Steps 1] :
1. Copy-kan file "php_pdo_sqlsrv_54_ts.dll" & "php_sqlsrv_54_ts.dll" ke folder "c:\xampp\php\ext\"
2. Edit file php.ini, tambahkan baris ini :

extension=php_sqlsrv_54_ts.dll
extension=php_pdo_sqlsrv_54_ts.dll

3. Restart Apache Service.

[Steps 3]. Setting Database Config di Codeigniter : (Contoh Settingan)
1. Edit file "application/config/database" :

$active_group = 'sqlsvr12';
$active_record = TRUE;
$db['sqlsvr12']['hostname'] = 'AXIOO-PC\SQLEXPRESS';
$db['sqlsvr12']['username'] = 'sa';
$db['sqlsvr12']['password'] = 'password';
$db['sqlsvr12']['database'] = 'db_test';
$db['sqlsvr12']['dbdriver'] = 'sqlsrv';
$db['sqlsvr12']['dbprefix'] = '';
$db['sqlsvr12']['pconnect'] = TRUE;
$db['sqlsvr12']['db_debug'] = TRUE;
$db['sqlsvr12']['cache_on'] = FALSE;
$db['sqlsvr12']['cachedir'] = '';
$db['sqlsvr12']['char_set'] = 'utf8';
$db['sqlsvr12']['dbcollat'] = 'utf8_general_ci';
$db['sqlsvr12']['swap_pre'] = '';
$db['sqlsvr12']['autoinit'] = TRUE;
$db['sqlsvr12']['stricton'] = FALSE;

2. Edit file "/system/database/drivers/sqlsrv/sqlsrv_driver.php" liat ini.
3. Done !