MS access connection

[eluser]chicoNERD[/eluser]
I do.
and even if that was the problem I installed CI in a server where I already use .mdb files for testing and even CakePHP is able to access the file, but I like CI the most so I want to be able to use it.

the error I get from my server is

Code:

$active_group = "access";
$active_record = TRUE;

$db['access']['hostname'] = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=C:\hosted web sites\council.org\testsite\db\test.mdb";
$db['access']['username'] = "ADODB.Connection";
$db['access']['password'] = "";
$db['access']['database'] = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=C:\hosted web sites\council.org\testsite\db\test.mdb";
$db['access']['dbdriver'] = "odbc";
$db['access']['dbprefix'] = "";
$db['access']['pconnect'] = TRUE;
$db['access']['db_debug'] = TRUE;
$db['access']['cache_on'] = FALSE;
$db['access']['cachedir'] = "";
$db['access']['char_set'] = "utf8";
$db['access']['dbcollat'] = "utf8_general_ci";

a quick check of the file returns true

Code:

is_file('=C:\hosted web sites\council.org\testsite\db\test.mdb'); //Returns true

the error im getting is

Code:

A Database Error Occurred
Unable to connect to your database server using the provided settings.