title: How to connect with sql server database with Codeigniter?
body: <p>Help will be appreciated.
  <Br>I am stuck and I am facing an error of Invalid DB driver Error. I had done research from my end. I had installed the driver of <code>sqlsvr</code> and add the extensions in <code>php.ini</code> file. I believe the driver is okay with the PHP version. <a href="https://i.stack.imgur.com/waKaI.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/waKaI.png" alt="enter image description here"></a></p>
  
  <p><code>extension=php_pdo_sqlsrv_71_ts.dll</code> and
  <code>extension=php_sqlsrv_71_ts.dll</code> in php.ini file.
  Then I try to make a connection with Codeigniter Database. </p>
  
  <p>$active_group = 'default';
      $query_builder = TRUE;</p>
  
  <pre><code>$db['default'] = array(
      'dsn'   =&gt; '',
      'hostname' =&gt; 'DESKTOP-Q52QI3K',
      'username' =&gt; 'noman',
      'password' =&gt; 'noman',
      'database' =&gt; 'TestDB',
      'dbdriver' =&gt; 'sqlsvr',
      'dbprefix' =&gt; '',
      'pconnect' =&gt; TRUE,
      'db_debug' =&gt; TRUE,
      'cache_on' =&gt; FALSE,
      'cachedir' =&gt; '',
      'char_set' =&gt; 'utf8',
      'dbcollat' =&gt; 'utf8_general_ci',
      'swap_pre' =&gt; '',
      'encrypt' =&gt; FALSE,
      'compress' =&gt; FALSE,
      'stricton' =&gt; FALSE,
      'failover' =&gt; array(),
      'save_queries' =&gt; TRUE
  );
  </code></pre>
  
  <p>I have this database on my local SQL server management tool. I am still facing the <code>Invalid DB driver</code> error.</p>