in reply to Perl to MS Access with DBI:ODBC on Unix

I have heard this question asked before adn I figured that I would respond. You cannot effectively use an Access .mdb on any *NIX box. Luckily, you can (apparently) use ADO from a *NIX box to access an Access database, but moving the DB to *NIX apparently only offers 'access to tables' as listed by somebody who has apparently tried it here.

I hope this helps.

Celebrate Intellectual Diversity

  • Comment on Re: Perl to MS Access with DBI:ODBC on Unix

Replies are listed 'Best First'.
Re: (InfiniteSilence) Re: Perl to MS Access with DBI:ODBC on Unix
by coreolyn (Parson) on Dec 28, 2000 at 21:28 UTC

    I guess that depends upon your definition of effective.

    You must be defining dbi database proxying as ineffective, (It is a performance pig) but it does work.


    update -- ack! There I go reading the post wrong -- again!

    Putting the *mdb ON the *nix box... ack.. I guess my brain didn't want to accept the concept!

    coreolyn

Re: Re: Perl to MS Access with DBI:ODBC on Unix
by fongsaiyuk (Pilgrim) on Dec 28, 2000 at 21:34 UTC
    Excellent! Thank you very much for your reply and off-site link.

    I'm not really an expert at the internals of Access, but it makes sense that the full features of the Jet engine cannot be used if the file is on the *nix box.

    Methinks a better option is going to be converting the Access database into a more friendly Database.

    Thanks again!