In codeigniter how to setup connection to a SQL server

Question

I have spent many days on this task, and I can not see the end until now.

settings in application/config/database.php

I have two servers, in first server i have installed PHP and Xammp and in 2nd server have SQL Server and authentication mode is Windows

$db['attn'] = array(
'dsn'   => '10.166.32.21',
'hostname' => 'APP01/MSSQLSERVER2012',
'username' => 'DOMAIN/Administrator',
'password' => '',
'database' => 'xample',
'dbdriver' => 'sqlsrv',
'dbprefix' => '',
'pconnect' => FALSE,
'db_debug' => (ENVIRONMENT !== 'production'),
'cache_on' => FALSE,
'cachedir' => '',
'char_set' => 'utf8',
'dbcollat' => 'utf8_general_ci',
'swap_pre' => '',
'encrypt' => FALSE,
'compress' => FALSE,
'stricton' => FALSE,
'failover' => array(),
'save_queries' => TRUE);

I have latest version of PHP and CodeIgniter

anything wrong is my configuration

public function connect_sql()
{
    try
    {
        $live = $this->load->database('attn',TRUE);
    }
    catch (Exception $e) 
    {
        echo 'Caught exception: ',  $e->getMessage(), "\n";
    }
}

Possible duplicate of [Codeigniter: How to setup connection to a SQL server (2008)](https://stackoverflow.com/questions/19431447/codeigniter-how-to-setup-connection-to-a-sql-server-2008) — ADreNaLiNe-DJ, Jun 28 '18 at 07:37
Have you installed the necessary drivers to be able to use mssql? PHP to MSSQL is tricky as you not only need to update your database config but you also have to install the necessary drivers. — hungrykoala, Jun 28 '18 at 07:39
What have you installed then? Did you also update php.ini to include the drivers? — hungrykoala, Jun 28 '18 at 07:41
Check `php_info()` to see if you have the necessary drivers for MSSQL — hungrykoala, Jun 28 '18 at 07:42
@hungrykoala yes i configured already, in same server its works normally — إرتقاء, Jun 28 '18 at 07:43

score 0 · Answer 1 · answered Jun 29 '18 at 20:46

0

'dsn'   => '',
'hostname' => '10.166.32.21',
'username' => 'your db user name',
'password' => 'your db password',

answered Jun 29 '18 at 20:46

Deepak Kr

381
3
5

In codeigniter how to setup connection to a SQL server

1 Answers1