in reply to Re^8: Fetching data from Access using DBI
in thread Fetching data from Access using DBI

mdbtools is flawed in a number of areas - you are really going to struggle to use this successfully as an ODBC driver. The last release was Jun 18 2004. I strongly suggest that if you absolutely have to access MS Access from a unix machine you consider using an ODBC-ODBC bridge or another commericial driver (as I know of no opensource one that is close to working) - mdbtools is not up to it.

By all means submit this to the dbi-users list but I am on that list and I maintain DBD::ODBC and I'm not going to spend any time on mdbtools because I've wasted too much time in the past debugging some code to find it is a buggy mdbtools. Believe me, it is not a viable option for accessing MDB files.

  • Comment on Re^9: Fetching data from Access using DBI

Replies are listed 'Best First'.
Re^10: Fetching data from Access using DBI
by hacheb (Novice) on Aug 12, 2009 at 16:19 UTC
    well, it looks like my problems are over, found this handy tool:

    http://www.enobis.com/sw/mdb2mysql/

    Did a dump of the database and it looks ok. it uses mdbtools.

    H
[reply]

      I am glad you are happy with this solution. DBD::mysql is miles better than DBD::ODBC with mdbtools (due to mdbtools having a truly horrendous ODBC driver) but I suspect in time you will find you have just swapped a large set of problems for a slightly smaller set of problems. Best of luck, I suspect you'll need it.

[reply]

        Thanks but what I only needed was a dumb of the database, after that, it's mysql all the way. And it allowed me to waste energy experimenting with dbi and odbc.

        H
[reply]

In Section Seekers of Perl Wisdom