Re^3: How can I connect my perl script to an Access 2010 (.accdb) file?

I've got it!

The problem was architecture. Even though my OS is 64 bit, my Office install (which is what I guess determines the architecture of the data access components), is 32 bit. There seemed to have been a communication issue where DBI interacted with the native data access stuff through Microsoft. I uninstalled Strawberry Perl 64 bit, deleted the CPAN modules (since it leaves it there after uninstall), and re-installed SP 32-bit. Then re-downloaded and re-compiled the CPAN modules and...there it is!

All of my queries are running happily now. Thanks to those who chimed in. On to the next crisis.

Comment on Re^3: How can I connect my perl script to an Access 2010 (.accdb) file?

Replies are listed 'Best First'.
Re^4: How can I connect my perl script to an Access 2010 (.accdb) file? by afoken (Chancellor) on Jun 03, 2012 at 15:44 UTC
For the archive: There are two distinct ODBC data source managers on Windows 64 bit editions, the obvious one works for 64 bit, the "hidden" one works for 32 bit. This is documented in DBD::ODBC::FAQ. Alexander -- Today I will gladly share my knowledge and experience, for there are no sweeter words than "I told you so". ;-)	[reply]