CodeIgniter 连接odbc

1、在数据库配置文件database.php中增加如下配置

$db['odbc']['hostname'] = 'DRIVER={SQL Server};SERVER=192.168.88.188\MSSQL2005;DATABASE=YYY';
$db['odbc']['username'] = 'sa';
$db['odbc']['password'] = '1234';
$db['odbc']['database'] = 'DB_JXIN';
$db['odbc']['dbdriver'] = 'odbc';
$db['odbc']['dbprefix'] = '';
$db['odbc']['pconnect'] = TRUE;
$db['odbc']['db_debug'] = TRUE;
$db['odbc']['cache_on'] = FALSE;
$db['odbc']['cachedir'] = '';
$db['odbc']['char_set'] = 'utf8';
$db['odbc']['dbcollat'] = 'utf8_general_ci';
$db['odbc']['swap_pre'] = '';
$db['odbc']['autoinit'] = TRUE;
$db['odbc']['stricton'] = FALSE;

2、测试

    function testodbc()
    {
        $db = $this->load->database('odbc',TRUE);
        $query = $db->query("select TOP 10 * from XXX");
        $result = $query->result();
        foreach ($result as $row){
            echo "FBillNo=>".$row->abc."<br>";
        }        
    }