title: Connect perl to ms access
body: <p>I am tring to retrive data from a table in access. The code is   </p>
  
  <pre><code>#!/usr/bin/perl  
  use strict;  
  use warnings;  
  use DBI;  
  my $DBFile  = qw(C:test\INSTRUCTIONS.mdb );   
  my $dbh = DBI-&gt;connect("dbi:ODBC:driver=microsoft access driver (*.mdb);dbq=$DBFile",'','') or die("cannot connect to DB");  
  my $SQLquery = "select * FROM IndemDate";  
  $dbh-&gt;Execute($SQLquery);  
  </code></pre>
  
  <p>This is the error i recieve  </p>
  
  <pre><code>DBI connect('driver=microsoft access driver (*.mdb);dbq=C:test\INSTRUCTIONS.mdb','',...) failed: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (SQL-IM002) at C:/Test/connectaccess.pl line 9.
  cannot connect to DB at C:/Test/connectaccess.pl line 9.
  </code></pre>
  
  <p>can someone help me rectify my error. Is there any driver I've missed to install.</p>