I'm modifying an app that currently creates Microsoft Access 2003 files, but also needs
to create Access 2007 files.
I updated the connection string in the function in a perl module so it specifies '.accdb' files in addition to '.mdb' files. However, when I try to test the code to create an Access 2007 file, I see the following error message in a log file:
Describe failed during DBI::st=HASH(0x40f84d4)->FETCH(NAME,0) at lib/searchInstance.pm line 784.
Can't set DBI::HASH(0x40f84d4)->{NAME_uc}: unrecognised attribute name or invalid value at lib/searchInstance.pm line
784.
Here is line 784:
foreach my $i (0..$#{dst_info_sth->{NAME_uc}}) {
$dst_info_sth represents a database statement handle:
...
my $dst_info_sql = "SELECT * FROM $to";
...
my $dst_info_sth = $dst_dbh->prepare($dst_info_sql);
...
Any ideas/suggestions to resolve this would be greatly appreciated.
