[eluser]rogierb[/eluser]
sure you can, just create a second db connection under a different name like:
$db['second_database']['hostname'] = "localhost";
$db['second_database']['username'] = "my_username";
$db['second_database']['password'] = "my_passwor";
$db['second_database']['database'] = "My_database";
$db['second_database']['dbdriver'] = "mssql";
$db['second_database']['dbprefix'] = "";
$db['second_database']['pconnect'] = TRUE;
$db['second_database']['db_debug'] = TRUE;
$db['second_database']['cache_on'] = FALSE;
$db['second_database']['cachedir'] = "";
$db['second_database']['char_set'] = "utf8";
$db['second_database']['dbcollat'] = "utf8_general_ci"
and then connect to it like:
$this->second_database = $this->load->database('second_database', TRUE);
And use that in the connection to the external mssql db.