Anonymous Monk has asked for the wisdom of the Perl Monks concerning the following question:

I was wondering whether there is a DBD driver to link Perl's DBI module to a small database i've got in Lotus Approach, which is similar to Microsoft Access?

Replies are listed 'Best First'.
Re: Lotus Approach
by dhable (Monk) on Apr 01, 2002 at 15:24 UTC
    Does Lotus Approach have an ODBC driver? If so, why not use DBD::ODBC or Win32::ODBC? A quick google search pointed me to a page with DBI FAQs. Take a look at section 3 for information on DBD and ODBC.
[reply]
Re: Lotus Approach
by gellyfish (Monsignor) on Apr 02, 2002 at 11:29 UTC

    From way back in the mists of time I seem to recall that Lotus Approach actually used an xBase format file (Like dBase or early Foxpro) - if this is the case then you should be able to use DBD::XBase with it otherwise the ODBC route as others have suggested seems fine ...

    /J\

[reply]
Re: Lotus Approach
by SageMusings (Beadle) on Apr 02, 2002 at 03:26 UTC
    Fellow Perl disciple,

    You said the database was small. How small? Could you export the data to another product? I ask because I do not know enough about Approach. I have, however, had stunning success with MS Access and ODBC. It has been a programmer's wet dream.

    It is not the fastest RDBMS on the planet, but it is nearly ubiquitous. I have not seen any Lotus products in the hands of customers for 5 years.
[reply]

Back to Seekers of Perl Wisdom