MDB Tools
MDB Tools is a set of utilities that can be used to read mdb format (Microsoft Access) database files on Linux.
It also comes with a gtk based graphical frontend tool called Gmdb (Gnome MDB Viewer) that can be used to read the table structure and data quickly and easily.
More information can be found at the project website http://mdbtools.sourceforge.net/.
On Ubuntu or Linux Mint it can be installed from synaptic -
$ sudo apt-get install mdbtools-gmdb
Then launch with the following command
$ gmdb2
Sir,
After installing
$sudo apt-get install mdbtools-gmdb
the MDBTools is not working Showing
“could not find driver ”
here is my php code —>
$database=”/opt/lampp/elibdata/database1.mdb”;
$driver = “MDBTools”;
try {
//$dbh = new PDO(“odbc:DSN=MS Access Database;DBq=$database;”);
$dbh = new PDO(“MDBTools:Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBq=$database;”);
//$dbh = new PDO(“pgsql:host=localhost;dbname=”,$database,””,””);
//$dbh = new PDO(“odbc:Driver=$driver;DBQ=$database”, “”, “”);
$dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$sql = “SELECT * FROM Admc”;
$STH = $dbh->query($sql);
$STH->setFetchMode(PDO::FETCH_ASSOC);
}
catch(PDOException $e) {
echo $e->getMessage().”n”;
exit;
}
#close the connection
$dbh = null;
Please guide me in this matter.
Thankx in Advance.
MNG