mssql connection works procedurally but not with database class

[eluser]bgreene[/eluser]
$this->load->database('mssqldb');
$qry = $this->db->query('select * from mytable');
foreach ($qry->result() as $row)
{
echo $row->Hosts;
}