There's more than one way to do things PerlMonks

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

by ikegami (Pope)
 on Apr 05, 2005 at 05:41 UTC ( #444867=note: print w/replies, xml ) Need Help??

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;
...
[download]

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.

Create A New User
Node Status?
node history
Node Type: note [id://444867]
help
Chatterbox?
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others pondering the Monastery: (4)
As of 2017-10-22 18:52 GMT
Sections?
Information?
Find Nodes?
Leftovers?
Voting Booth?
My fridge is mostly full of:

Results (274 votes). Check out past polls.

Notices?