title: How do I connect to a SQL Server database in CodeIgniter?
body: <p>How do I connect to a SQL Server database in CodeIgniter?</p>
  
  <p>I'm currently starting an application in CodeIgniter and I would like to use SQL Server.</p>
  
  <pre><code>$active_group = 'default';
  $active_record = TRUE;
  
  $db['default']['hostname'] = '#.#.#.27';
  $db['default']['username'] = '@@@@@@';
  $db['default']['password'] = '@@@@@@@@@';
  $db['default']['database'] = '$$$$$$$$$$$$$';
  $db['default']['dbdriver'] = 'mssql';
  $db['default']['dbprefix'] = '';
  $db['default']['pconnect'] = TRUE;
  $db['default']['db_debug'] = TRUE;
  $db['default']['cache_on'] = FALSE;
  $db['default']['cachedir'] = '';
  $db['default']['char_set'] = 'utf8';
  $db['default']['dbcollat'] = 'utf8_general_ci';
  $db['default']['swap_pre'] = '';
  $db['default']['autoinit'] = TRUE;
  $db['default']['stricton'] = FALSE;
  </code></pre>
  
  <p>After auto-loading the database, it shows just a blank white page with no errors. Can you please tell me what other changes I have to make to work with the SQL Server database?</p>
  
  <pre><code>#autoload.php#
  $autoload['libraries'] = array('database');
  </code></pre>