Beefy Boxes and Bandwidth Generously Provided by pair Networks
Come for the quick hacks, stay for the epiphanies.
 
PerlMonks  

How to connect MS Access Database?

by pysome (Scribe)
on Mar 28, 2008 at 03:28 UTC ( [id://676895]=perlquestion: print w/replies, xml ) Need Help??

Help for this page

Select Code to Download


  1. or download this
    use strict;
    use DBI;
    my $dbh = DBI->connect("dbi:ODBC:driver=Microsoft Access Driver (*.mdb
    +, *.accdb);dbq=a.mdb")
             or         die "Can't connect to Database: $DBI::errstr";
    
  2. or download this
    DBI connect('driver=Microsoft Access Driver (*.mdb, *.accdb);dbq=a.mdb
    +','',...) failed: [unixODBC][Driver Manager]Data source name not foun
    +d, and no default driver specified (SQL-IM002) at ./test.pl line 4
    Can't connect to Database: [unixODBC][Driver Manager]Data source name 
    +not found, and no default driver specified (SQL-IM002) at ./test.pl l
    +ine 4.
    

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: perlquestion [id://676895]
Approved by ww
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others lurking in the Monastery: (5)
As of 2024-04-25 10:22 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found