![]() |
Database Connection - Printable Version +- CodeIgniter Forums (https://forum.codeigniter.com) +-- Forum: Using CodeIgniter (https://forum.codeigniter.com/forumdisplay.php?fid=5) +--- Forum: General Help (https://forum.codeigniter.com/forumdisplay.php?fid=24) +--- Thread: Database Connection (/showthread.php?tid=73413) |
Database Connection - amansusanto - 04-21-2019 <?php defined('BASEPATH') OR exit('No direct script access allowed'); $active_group = 'default'; $query_builder = TRUE; $db['default'] = array( 'dsn' => '', 'hostname' => '192.168.1.55', 'username' => 'sa', 'password' => 'admin1234', 'database' => 'MyDatabase', 'dbdriver' => 'sqlsrv', 'dbprefix' => '', 'pconnect' => TRUE, '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 ); this is my database connection and working fine... but when i copy folder to run at another computer it's now working error : unable to connect to your database server using the provided setting. i try to change 'db_debug' => FALSE, it's working but some CI function not working like : num_rows() , etc.. i use xampp, and sql server database RE: Database Connection - DELE - 04-21-2019 try changing the value of 'hostname' => 'ip set on the computer' or 'hostname' => 'localhost' RE: Database Connection - amansusanto - 04-21-2019 i have tried nothing change. my php version 7.3.2 xampp 3.2.2 RE: Database Connection - DELE - 04-21-2019 show your database RE: Database Connection - amansusanto - 04-21-2019 the problem is not in database because my application running well the problem is when i copy to another computer RE: Database Connection - amansusanto - 04-22-2019 Done.. the problem is ODBC Driver to Sql Server RE: Database Connection - InsiteFX - 04-22-2019 Did you try this? 7 Steps to make SQL Server and Codeigniter Works |