How can I create / access / manipulate an MS Access Database w/ PERL

[SWAFO]

I have been working on a couple small projects for myself using a flat database with PERL. I enjoy using PERL a lot, and I now have a client that is requiring me to use PERL for a project of theirs. This project would be done best with the use of a real database. I don't NEED to use an access database. But it would ba handy for other purposes. Does anyone have any good suggestions of websites or script examples that could help me learn how to manipulate a database with PERL? Thanks in advance for any help.

--SWAFO

 

[Deleted]

Start here if you are going to take the Windows route.

http://www.iodbc.org/

Personally I would use MySQL for your database needs.

http://www.mysql.com/documentation/index.html

M. Brooks
X Concepts LLC

http://xconcepts.com

 

[SWAFO]

Thank you mbrooks for the sites. They look like they will be helpful. However, I was wondering if there was anything I could use that would ALSO work for unix (RedHad Linux to be precise). My personal server is a redhat box. So I do most of my testing there. I'm perfectly happy going the MySQL route. I'm just looking for some universal PERL methods to create/manipulate a database. Thanks again for the help. I really appreciate it!

--SWAFO

 

[icrf]

You're talking about the DBI. You could start at the FAQ [1] and google out from there for tutorials. I have the book mentioned in the FAQ from O'Reilly and like it a lot. DBI abstracts the database handling for you, so a swap from one database to another is often just a simple change in the connect statement.

[1]

http://search.cpan.org/~adesc/DBI-FAQ-0.38/FAQ.pm

________________________________________
Andrew - Perl Monkey

 

[tviman]

SWAFO - go to CPAN and search for DBI::ODBC. You'll need this module installed in order to access an MS Access database.

There's always a better way. The fun is trying to find it!