WIN32::ODBC - Unable to make Database connection

  • Thread starter Thread starter wmitty
  • Start date Start date
W

wmitty

Not sure this is right forum, but here goes:

Runnins IIS (personal web server) and trying to update Access 2003 database
via perl script using the following:

$DSN = "Test";
use Win32::ODBC;
$db = new win32::ODBC($DSN);
$db->sql("select * from SiteVisits where script_name = "counter" ");

Error: [-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."

As best I can determine tll files/databases have "full" permissions.

Help!!!

If this is not the correct forum please direct me to the correct one. Thanks.
This attempt nets the following error:
 
Back
Top