"be consistent" 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.

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

Create A New User
Node Status?
node history
Node Type: note [id://444867]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others browsing the Monastery: (7)
As of 2014-04-17 22:26 GMT
Sections?
Information?
Find Nodes?
Leftovers?
Voting Booth?