Query multiple databases

[eluser]Eildydar[/eluser]
I am trying to query multiple databases within the same page and I am having trouble getting it to work. in my model I have the following.

Code:

foreach($query->result() as $row) {
          $data[] = $row;
      }

And that works fine but if I try and add

Code:

$mysql = $this->load->database('default');
$odbc = $this->load->database('odbc');

$query = $mysql->query("SELECT * FROM db");
foreach($query->result() as $row) {
          $q = $odbc->query("SELECT * FROM otherDb WHERE field = $row->field");
          $result = $q->result()
          $return = array_merge($row, $result);
          $data[] = $return;
      }

But I keep getting an error stating "You have not selected a database type". This is a code igniter error and doesn't show up in any logs anywhere for php or apache.

Is this something that should be possible?