<?php $dbname = APPPATH.'database/myfile.mdb'; $access['hostname'] = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=".$dbname; $access ["username"] = ""; $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); // mastersettings record save 1 $data = $access_db->query("SELECT * FROM users"); print_r($data); ?>
I have applied this code to get data from MDB to MySQL using Codeigniter. I getting this error
Message: Call to undefined function odbc_connect()
Filename: E:xampphtdocsTechPlaasticTechPlaasticCompanysystemdatabasedriversodbcodbc_driver.php
Line Number: 141
How can I fix this error?
Question and answer is powered by AnsPress.io