How to connect to SQL Server database in CodeIgniter?

use use $ db ['default'] ['dbdriver'] = 'sqlsrv';
and install Microsoft Drivers for PHP for SQL Server on windows

CodeIgniter MSSQL Connection

The configuration code is fine. Further reading here

IF you think the errors are not showing, then go to index.php

and the following snippet will appear at the top to show the errors.

error_reporting(E_ALL);

      

        
        
        
      

    

Other, then check if the MSSQL service is running and available. Can be set up simple .php

and try connecting with regular codes .

File without CI Something like

<?php
$server = 'YOURPC\SQLEXPRESS';
$link = mssql_connect($server, 'user', 'pass');

if (!$link) {
    die('Something went wrong while connecting to MSSQL');
}
?>

      

        
        
        
      

    

this is the same process as mysql. use the same configuration as below:

$ active_group = 'default'; $ active_record = TRUE;

$ db ['default'] ['hostname'] = 'xxx.xx.xx.xx \ SQLEXPRESS';

$ db ['default'] ['username'] = 'sa';

$ db ['default'] ['password'] =

'XXXXXXX'; $ db ['default'] ['database'] = 'xxxxx';

$ 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;

In your model use the same as

selectagent function ($ table, $ agent) {

$ field = $ this-> db-> get_where ($ table, array ('var1' => $ Agent, 'day (date)' => date ('d')));

  $fields=$field->result();

  return $fields;
}

      

        
        
        
      

    

I just solved this problem. And I was connecting to MSSQL hosted with microsoft Azure

The steps I followed after doing some research on the internet are as follows:

database.cfg:

$db['default']['hostname'] = 'XXXXXXX.database.windows.net';
$db['default']['username'] = 'username';
$db['default']['password'] = 'password';
$db['default']['database'] = 'databasename';
$db['default']['dbdriver'] = 'sqlsrv';
$db['default']['dbprefix'] = '';
$db['default']['pconnect'] = FALSE;
$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;

      

        
        
        
      

    

Basically dbdriver, pcconnect and hostname you have to set up correctly. Rest is common. Get hostname from your azure database data.

And I also modified a couple of system files since I heard about DB driver issues.

System / databases / drivers / sqlsrv / sqlsrv_driver.php

function db_pconnect()
    {
        //$this->db_connect(TRUE);
        return $this->db_connect(TRUE);
    }

      

        
        
        
      

    

and

function affected_rows()
{
    //return @sqlrv_rows_affected($this->conn_id);
    return @sqlsrv_num_rows($this->result_id);
}

      

        
        
        
      

    

I was able to connect to the database and create a database application.

Hope this helps someone needing it :)