Re^2: How to link Ms-access data's in perl

[ikegami]

in reply to Re: How to link Ms-access data's in perl
in thread How to link Ms-access data's in perl

ADO supposedly works great:

my $db_file   = 'd:\path\to\database.mdb';
my $db_user   = 'username';
my $db_passwd = 'pasword';

my $dbh = DBI->connect(
   'dbi:ADO:Provider=Microsoft.Jet.OLEDB.4.0;Data Source='.$db_file,
   $db_user,
   $db_passwd
) or die $DBI::errstr;
...

It bypasses ODBC which ends up connecting to the Jet Engine anyway. It also saves you from creating ODBC DSNs in the Control Panel. (yeah, I suppose you could use DSN-less ODBC connection, but people don't seem to do that for some reason.)

Update: oops, this was supposed to be a reply to the OP.