in reply to MS Access and Perl?

DBI talks happily to Access databases.

DWIM is Perl's answer to Gödel

Replies are listed 'Best First'.
Re^2: MS Access and Perl?
by samtregar (Abbot) on May 24, 2006 at 18:36 UTC
    It does? What DBD would you use? Naive searchs on CPAN aren't pulling anything up. Seems like DBD::ADO might work, but it's not exactly obvious.

    -sam

[reply]

      In the past I've used code that starts:

      use strict;
use warnings;
use DBI;

my $db_file   = 'C:\...\database.edb';
my $dbh = DBI->connect
  ('dbi:ADO:Provider=Microsoft.Jet.OLEDB.4.0;Data Source=' . $db_file)
  or die $DBI::errstr;

      [download]

      'database.edb' is an access database file. I don't recall any problem getting it to go, but it was some time ago now.

      DWIM is Perl's answer to Gödel
[reply]
[d/l]

In Section Seekers of Perl Wisdom