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] [Watch: Dir/Any] |
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] [Watch: Dir/Any] |
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] [Watch: Dir/Any] |