Beefy Boxes and Bandwidth Generously Provided by pair Networks
"be consistent"

Microsoft Access Database

by bkiahg (Pilgrim)
on May 08, 2004 at 18:24 UTC ( #351742=perlquestion: print w/replies, xml ) Need Help??

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

I'm using a Microsoft Access database. Which module would be the best to use for it? Perl 5.8 IIS 5

Replies are listed 'Best First'.
Re: Microsoft Access Database
by matija (Priest) on May 08, 2004 at 18:37 UTC
    DBI and DBD::ODBC would seem to be the most appropriate combination for that task.
      I was about to post and say that while DBD::ODBC is preferable from a programming standpoint, it has the inconvenience that it requires you to setup an explicit DSN in your ODBC Data Sources area. But I would have been wrong! To quote from the POD:
      Example (using MS Access): my $DSN = 'driver=Microsoft Access Driver (*.mdb);dbq=\\\\cheese\\g$\\perltest.mdb'; my $dbh = DBI->connect("dbi:ODBC:$DSN", '','') or die "$DBI::errstr\n";

      Obviously, the usual caveats about using Access programmatically apply (it's a single user database so watch out for threading and locking issues, it should be located preferably on the same machine as the application or at least within the same LAN, etc). I had the experience of trying to programmatically fetch data from .MDB files on machines halfway across a large corporate Intranet. It wasn't pretty.

Log In?

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

How do I use this? | Other CB clients
Other Users?
Others scrutinizing the Monastery: (4)
As of 2021-10-19 08:36 GMT
Find Nodes?
    Voting Booth?
    My first memorable Perl project was:

    Results (76 votes). Check out past polls.