Error connecting to SQL Server

[eluser]hsdell[/eluser]
Hi All,

I'm just getting back to exploring CI after a long hiatus. I had done some stuff last year and was using version 1.3.3 connecting to SQL Server with no problems.

I just added version 1.5.4 and running in parallel with previous version, but I cannot get my new install to work at all with the database or logging (permissions?), while the original work I did works fine with SQL Server. So far, everything else about the new 1.5.4 install works as far as calling controllers, routing, etc.

I have tried using the same db config parms in both:

Code:

$db['default']['hostname'] = "localhost";
$db['default']['username'] = "ESCUSER";
$db['default']['password'] = "escuserpwd";
$db['default']['database'] = "wiqe";
$db['default']['dbdriver'] = "odbc";
$db['default']['dbprefix'] = "";
$db['default']['active_r'] = TRUE;
$db['default']['pconnect'] = FALSE;
$db['default']['db_debug'] = TRUE;
$db['default']['cache_on'] = FALSE;
$db['default']['cachedir'] = "";

Controller:

Code:

class Org3 extends Controller {

    function Org3()
    {
         parent::Controller();      
         $this->load->model('Org_model', '', TRUE);
    }

    function index() {

        $data['resultset'] = $this->Org_model->list_all();
        $this->load->view('org_result', $data);    
    }
}

Works with 1.3.3 installation, and fails with 1.5.4 installation with error:

Code:

An Error Was Encountered

Unable to connect to your database server using the provided settings.

I'm thinking something about the drivers has changed between versions and I need to do something else to connect.

Any help will be greatly appreciated!

Thanks.