in reply to Unable to connect to access 2007 from perl

Access 2007 makes significant changes to the database format. Microsoft provides additional data connection components for making ODBC connections to Access 2007. The only catch is that these components won't install on Windows 2000 Server.

I don't have Access 2007 on the systems I am using now, so I can't thoroughly test it. Let us know if installing these additional components works for you.

  • Comment on Re: Unable to connect to access 2007 from perl

Replies are listed 'Best First'.
Re^2: Unable to connect to access 2007 from perl
by prathap (Initiate) on Mar 19, 2008 at 04:39 UTC
    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;
[reply]
      I have tried using the above suggestion. It still deos not work out for me
[reply]

In Section Seekers of Perl Wisdom