Beefy Boxes and Bandwidth Generously Provided by pair Networks
XP is just a number

Lotus Approach

by Anonymous Monk
on Apr 01, 2002 at 14:02 UTC ( [id://155755]=perlquestion: print w/replies, xml ) Need Help??

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.
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 ...


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.

Log In?

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: perlquestion [id://155755]
Approved by root
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others having a coffee break in the Monastery: (4)
As of 2024-04-20 19:29 GMT
Find Nodes?
    Voting Booth?

    No recent polls found