[eluser]vinci777[/eluser]
[quote author="Andi Eko" date="1204037609"]I have the same problem.
$active_group = "default";
$active_record = TRUE;
$db['default']['hostname'] = "169.254.216.4";
$db['default']['username'] = "sa";
$db['default']['password'] = "password";
$db['default']['database'] = "Billing";
$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";
And here the error :
An Error Was Encountered
Unable to connect to your database server using the provided settings.
I'm not try to connect manually, I just use this code :
$this->load->database();
It doesn't work ? any solution ?[/quote]
i found the problem...~it is because of the version of the MSSQL.... mine is MSSQL 2005...i tested in a few pc with the MSSQL 2000 then can connect edi...
read up a few forum...PHP have some limitations or bug connecting to MSSQL 2005....i guess so