[eluser]Justin Patel[/eluser]
i also had the same problem,
but I have some temporary solutions
take a look sample below
for this do not put database library in to auto load
Code:
// FIRST DATABASE Connection { Temporary }
//----------------------------------------------------------------
$dbh=mysql_pconnect ("localhost", "costa04_affiliat", "XXXXX") or die ('I cannot connect to the database because: ' . mysql_error());
$dbname = 'costa04_affiliate';
mysql_select_db($dbname);
$sg = mysql_query("select * from test")or die(mysql_error());
while($row = mysql_fetch_array($sg))
echo $row['name']."<br>";
mysql_close();
// do your work with first database
//-------------------------------------------------------------------
// the function need the another database connection do below code
//------------------------------------------------------------------
//-------- This is the database define in the config/database.php
$shreeGanesh = $this->load->database();
$this->load->model('servers_model');
$this->load->model('proxy_model');
//------------------------------------------------------------------
I have used the both in the single function and its working great
take a try