RE: :ODBC in a web application

There are probably a few things here. Apache typically runs under a
different user as a Windows service. Typically, this is the local
system user. Local System doesn't have access to UNC (network) drives.
You need to make the service run as a network-capable user. Keep using
UNCs. Drive mappings in services, to say the least, are a mess.

If you can move the db to a local drive to test (if it's NTFS, also
ensure the user has permissions to the path :)), that should help
isolate the problem to Apache/DBI/DBD::ODBC and get rid of (at least
temporarily) the UNC/Network as an issue.

Then, as far as the environment goes, if you don't specify the Env as
per the other posts, you won't get the environment. However, I see
here, you are using a UNC to an MDE? I'm not sure what that is (typo?
Encrypted MDB?).

Jeff

-----Original Message-----
From: Robert Hicks [mailto:sigzero@xxxxxxxxxxxxx]
Sent: Thursday, March 23, 2006 7:13 AM
To: dbi-users@xxxxxxxx
Subject: 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 ... 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: 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)
  • 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. ... I am not sure if the problem resides with Apache, the modules I am using for the web application of DBD::ODBC itself. ...
    (perl.dbi.users)
  • any reason for a valid shell for httpd user?
    ... I was just looking through /etc/passwd and noticed that the apache ... system user has /bin/sh, whereas most system users don't seem to have a ... valid shell. ... my first name at josecrappus dot com ...
    (comp.os.linux.security)