DBD::ODBC in a web application



If I create a test script to connect to a Microsoft Access database that is on a network (UNC) drive I can connect to it fine.

If I try to do the same thing from a web application running under Apache I get the following error:

Error executing run mode 'display_task_page': Can't connect to data source driver=Microsoft Access Driver (*.mdb);dbq=\\Resolver\Users\BHicks\Public\Project_task_report_2003.mde, no database driver specified and DBI_DSN env var not set at C:/Perl/site/lib/CGI/Application/Plugin/DBH.pm line 42
at D:/Projects/www/DEV/exp/index.cgi line 14

I have tried mapping that UNC path to a local drive letter as well with the same error.

I am not sure if the problem resides with Apache, the modules I am using for the web application of DBD::ODBC itself.

Any pointers?

Robert
.



Relevant Pages

  • RE: DBI::ODBC in a web application
    ... If I create a test script to connect to a Microsoft Access database ... that is on a network drive I can connect to it fine. ... I have tried mapping that UNC path to a local drive letter as well ... I am not sure if the problem resides with Apache, ...
    (perl.dbi.users)
  • Re: DBI::ODBC in a web application
    ... If I create a test script to connect to a Microsoft Access database ... I have tried mapping that UNC path to a local drive letter as well ... I am not sure if the problem resides with Apache, ... I had similar trouble getting DBI running under the control of the ...
    (perl.dbi.users)
  • RE: :ODBC in a web application
    ... system user. ... Local System doesn't have access to UNC drives. ... Apache I get the following error: ... Error executing run mode 'display_task_page': ...
    (perl.dbi.users)