CodeIgniter Forums

Full Version: Connecting odbc to ms access
You're currently viewing a stripped down version of our content. View the full version with proper formatting.

El Forum

[eluser]edhrx[/eluser]
Hi,
I am struggling to connect to ms access this is the configuration
$db['default']['hostname'] = "localhost";
$db['default']['username'] = "";
$db['default']['password'] = "";
$db['default']['database'] = "cp";
$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";


cp does exists as a data source but the logs are showing

SQL error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified