Do you know where your variables are? 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 the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others studying the Monastery: (12)
As of 2016-08-24 15:02 GMT
Sections?
Information?
Find Nodes?
Leftovers?
Voting Booth?
The best thing I ever won in a lottery was:

Results (347 votes). Check out past polls.