in reply to Re: Unable to connect to access 2007 from perl
in thread Unable to connect to access 2007 from perl

I downloaded the components and installed. but still i am getting same error. I am using DBI and ODBC to connect to acces, so do i need any extra modules or updated module for connecting to access 2007. This is my code : use DBI; my($file) = @ARGV; my $DSN = "DRIVER=Microsoft Access Driver (*.mdb, *.accdb);dbq=$file"; print($DSN); $dbh = DBI->connect("dbi:ODBC:$DSN", '', '', { RaiseError => 0, AutoCommit => 0, PrintError => 0, LongReadLen =>1000, LongTruncOk => 1 })||die print $DBI::errstr;
  • Comment on Re^2: Unable to connect to access 2007 from perl

Replies are listed 'Best First'.
Re^3: Unable to connect to access 2007 from perl
by perl_gem (Initiate) on Feb 27, 2012 at 06:58 UTC
    I have tried using the above suggestion. It still deos not work out for me