Does anyone know why (in Windows) I would be getting "invalid ODBC-resource link" errors when I try to access an MS Access database via a Perl script via the web, but when I use Perl on the command line I have no problem? I'm using IIS as the web server, Perl as the CGI handler, and MS Access as the database. I've already configured IIS to run well with Perl, so that connection should be working fine. I've also created an ODBC Data Source Name to connect with the database named "Demo".
Is there any kind of permissions problem that could be occurring? Does the database file have to be in a place available to the web server? Does it have to be in the \InetPub\wwwroot\ directory?