Re: DBI::ODBC in a web application

On 23/03/06, Garrett, Philip (MAN-Corporate) <Philip.Garrett@xxxxxxxxxxx> wrote:
-----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\BH-
icks\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?

It looks like the "dbi:ODBC:your_datasource_name" parameter isn't making
it into the DBI->connect call (although some part of it is).

If you enable DBI->trace(1), the call to DBI->connect will go into your
Apache error_log, so you can see exactly what is getting passed to the
connect method.

Philip


I had similar trouble getting DBI running under the control of the
Apache userid and got round it by setting the environment for the web
server in httpd.conf:

SetEnv LD_LIBRARY_PATH /usr/local/OraClient/instantclient_10_2/lib
SetEnv ORACLE_HOME /usr/local/OraClient/instantclient_10_2

You will obvoiusly need different values but something like this might
work fo ryou.

hth
--
cheers,
victor

Victor Churchill, Bournemouth, U.K.
.

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)
  • 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)
  • 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)