MDB
Moderator: General Moderators
You can access ODBC with PHP, so that means that anything that provides a ODBC driver for you platform it would work..
So, as far as I know there is no drivers/engines for WIlliam-db-files on a Linux/Unix system, but, if your PHP/Web server runs on William and the database files resides on a William Machine that is possible.. It is also somewhat possible if the the PHP/Webserver runs on a Linux/Unix system and the Database/File resides on (or at least accessed thru) a WIlliam machine, using a ODBC bridge like the one available from Openlink...
Search the net for iODBC and UnixODBC for Linux/Unix ODBC driver manages, search for OpenLink for universal ODBC drivers.. there may be some others around but they probably cost a bit...
Officially PHP doesnt support UnixODBC, but, I have gotten UnixODBC->Openlink ODBC-Bridge->windows/mdb-file to work.. but, and a big butt, it was not stable, now and again PHP would bail/end prematurely without an during a query, and UPDATE/INSERT would something fail/not-do-it without an error.. I have no idea if that would have been different by using iODBC instead..
Bottom line (my opinion): Using William-DB (mdb) files for any type data storage is "stupid", inefficient and not necessary. Access has a fairly good wizardy-IDE for building simple to somwhat complex database frontends, data storage sucks.. so, install a DB-Engine, like PostgreSQL, and export all your data there and just link to the ODBC tables from the Access frontend..
Bottom line,
So, as far as I know there is no drivers/engines for WIlliam-db-files on a Linux/Unix system, but, if your PHP/Web server runs on William and the database files resides on a William Machine that is possible.. It is also somewhat possible if the the PHP/Webserver runs on a Linux/Unix system and the Database/File resides on (or at least accessed thru) a WIlliam machine, using a ODBC bridge like the one available from Openlink...
Search the net for iODBC and UnixODBC for Linux/Unix ODBC driver manages, search for OpenLink for universal ODBC drivers.. there may be some others around but they probably cost a bit...
Officially PHP doesnt support UnixODBC, but, I have gotten UnixODBC->Openlink ODBC-Bridge->windows/mdb-file to work.. but, and a big butt, it was not stable, now and again PHP would bail/end prematurely without an during a query, and UPDATE/INSERT would something fail/not-do-it without an error.. I have no idea if that would have been different by using iODBC instead..
Bottom line (my opinion): Using William-DB (mdb) files for any type data storage is "stupid", inefficient and not necessary. Access has a fairly good wizardy-IDE for building simple to somwhat complex database frontends, data storage sucks.. so, install a DB-Engine, like PostgreSQL, and export all your data there and just link to the ODBC tables from the Access frontend..
Bottom line,