ms access db config

[eluser]edhrx[/eluser]
Hi
I'm trying to connect an access db. Using odbc but not getting anywhere. This is the configuration


$db['default']['hostname'] = "localhost";
$db['default']['username'] = "";
$db['default']['password'] = "";
$db['default']['database'] = "cops";
$db['default']['dbdriver'] = "odbc";
$db['default']['dbprefix'] = "";
$db['default']['pconnect'] = TRUE;
$db['default']['db_debug'] = TRUE;
$db['default']['cache_on'] = FALSE;
$db['default']['cachedir'] = "";
$db['default']['char_set'] = "utf8";
$db['default']['dbcollat'] = "utf8_general_ci";

cops = the dsn name.

Can someone 'show me the light' on this as I have tried several combinations with no effect


Ed..

[eluser]edhrx[/eluser]
Sorry, if a moderator sees this can they post into the correct forum

ed..

[eluser]edhrx[/eluser]
sorted...but I don't know why

I replaced $db[‘default’][‘hostname’] = “localhost”;
with
$db[‘default’][‘hostname’] = “cops”; and it worked.