John Davidson

Message:

I am trying to connect Ms Access database in CodeIgniter but I am getting following error
Message: odbc_connect(): SQL error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified, SQL state IM002 in SQLConnect

My db connection.

$dbname = 'C:/xampp/htdocs/personal/naaz/TimeData 13april.mdb'; 

$access['dsn'] = "DRIVER={Microsoft Access Driver (* .mdb)}; DBQ= {$dbname}";

$access['hostname'] = "DRIVER={Microsoft Access Driver (* .mdb)}; DBQ= {$dbname}";

$access['username'] = "localhost";

$access['password'] = "";

$access['database'] = $dbname; 



$access['dbdriver'] = "odbc";

$access['dbprefix'] = "";

$access['pconnect'] = FALSE;

$access['db_debug'] = FALSE;

$access['cache_on'] = FALSE;

$access['cachedir'] = "";

$access['char_set'] = "utf8";

$access['dbcollat'] = "utf8_general_ci";

$access['swap_pre'] = '';

$access['autoinit'] = TRUE;

$access['stricton'] = FALSE;





$access_db = $this->load->database($access, true);



$result = $this->db->select('*')->get('user')->result_array(); 

print_r(json_encode($result));

please help anyone, any help would be appreciated.

---

My Answer:
"Driver={Microsoft Access Driver (*.mdb)};Dbq=$dbname;Uid=;Pwd=;"

Try using this connection string in your database configuration file in CodeIgniter. Make sure to replace $dbname with the path to your MS Access database file. This should help you connect to your MS Access database successfully.