+- 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