Accessing MDB's VIA PHP on Linux (RH8)

Posted on 2006-04-05
Last Modified: 2008-02-26
Hello there, scoured the interweb for the best half of this morning for a solution, but hit a brick wall.

I need to be able to create an MDB in PHP on a linux webserver using PHP. So far I have installed libodbc and now I need to find a driver for it, or perhaps an easier way of doing this.

The PHP side is fine, I just need to know how to get libodbc to connect to an mdb and be able to select/insert/delete

Question by:Furiam
    LVL 2

    Author Comment

    Even a way just to binary write an MDB would be suitable as well, I just need to batch export an MDB once a week.
    LVL 22

    Accepted Solution

    I'm not sure that there is a suitable linux interface to enable you to work directly with MSAccess mdb files.

    Possibly a better solution would be to work with dbf files as they can be relatively easily imported into MS Access.

    However...that wasn't the answer you wanted, so I'll give you an interesting avenue to try. It appears that want you wan **IS** possible under WINE/Crossover office:

    Key paragraph is:

    Well, I do. In the same setup as before, I have been able to use the *native*
    odbc32.dll ODBC driver by pulling it from a real Windows instalation and adding
    "odbc32"="native,builtin" in the config file. I Installed the psqlodbc driver
    from the Postgres database, and retried : selecting "ODBC sources" in the
    "Attach tables" dialog box led me to the usual ODBC manager dialogs, where I
    have been able to create a DSN to my Postgres database. I have then been able
    to "Attach" my Postgres tables and views to an M$ Access database and peruse


    may also be of use.

    Alternatively, it may be possible to create some form of networked ODBC connection with the mdb hosted on a windows system.

    Unfortunately my main experience with this is using java, and that works very nicely on a linux platform!:)

    LVL 2

    Author Comment

    Wow, talk about 'round the houses' job that one :)

    Points are yours if I get nothing direct.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    SSH (Secure Shell) - Tips and Tricks As you all know SSH(Secure Shell) is a network protocol, which we use to access/transfer files securely between two networked devices. SSH was actually designed as a replacement for insecure protocols that sen…
    The purpose of this article is to show how we can create Linux Mint virtual machine using Oracle Virtual Box. To install Linux Mint we have to download the ISO file from its website i.e. Once you open the link you will see …
    Connecting to an Amazon Linux EC2 Instance from Windows Using PuTTY.
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now