MDB

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
airo
Forum Commoner
Posts: 31
Joined: Thu Apr 24, 2003 4:07 pm

MDB

Post by airo »

Im just curious, but i've heard rumors that PHP was able to access MDB's via ODBC commands, anyone know if this is true or not, and if so, where i can find any information on it?
User avatar
Stoker
Forum Regular
Posts: 782
Joined: Thu Jan 23, 2003 9:45 pm
Location: SWNY
Contact:

Post by Stoker »

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,
airo
Forum Commoner
Posts: 31
Joined: Thu Apr 24, 2003 4:07 pm

Post by airo »

Wow, danke... infact uber danke, that was a very informative post.

The reason asked, i wanted to get some experience using MDB files before i jumped headlong into another programming panguage like CFM which i plan to undertake soon.

Thanks again :D
Post Reply