I have created a System DSN for the file I wish to open. However, whenever I move to another script to handle other processing tasks, it gives me the following error:
couldn't open Purchase Order DB: po because -1032[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data.</br> at C:/Perl/lib/functions.lib line 7.
I have closed the connection to the database from script1 by using the $db->close() method. However when I go to connect to the DB again it gives me this error. The code contained within the functions.lib is the following:
sub connecttodsn
{
$DSN = "po";
#Connect to PO DB
$_[0]=new Win32::ODBC($DSN) or die "couldn't open Purchase Order DB: $DSN because ", Win32::ODBC::Error(), "</br>";
}
1;
Help please:
Ben
couldn't open Purchase Order DB: po because -1032[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data.</br> at C:/Perl/lib/functions.lib line 7.
I have closed the connection to the database from script1 by using the $db->close() method. However when I go to connect to the DB again it gives me this error. The code contained within the functions.lib is the following:
sub connecttodsn
{
$DSN = "po";
#Connect to PO DB
$_[0]=new Win32::ODBC($DSN) or die "couldn't open Purchase Order DB: $DSN because ", Win32::ODBC::Error(), "</br>";
}
1;
Help please:
Ben