Error connecting to SQL Server

#1
[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.


Messages In This Thread
Error connecting to SQL Server - by El Forum - 01-09-2008, 09:06 PM
Error connecting to SQL Server - by El Forum - 01-09-2008, 10:10 PM
Error connecting to SQL Server - by El Forum - 01-09-2008, 10:59 PM
Error connecting to SQL Server - by El Forum - 01-09-2008, 11:42 PM
Error connecting to SQL Server - by El Forum - 01-10-2008, 12:33 AM
Error connecting to SQL Server - by El Forum - 01-10-2008, 12:42 AM
Error connecting to SQL Server - by El Forum - 01-10-2008, 01:01 AM
Error connecting to SQL Server - by El Forum - 01-10-2008, 01:35 AM
Error connecting to SQL Server - by El Forum - 01-10-2008, 01:40 AM
Error connecting to SQL Server - by El Forum - 01-10-2008, 06:11 AM
Error connecting to SQL Server - by El Forum - 01-16-2008, 01:39 AM
Error connecting to SQL Server - by El Forum - 01-16-2008, 04:31 AM
Error connecting to SQL Server - by El Forum - 01-16-2008, 10:02 AM

Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2020 MyBB Group.