[KLUG Members] Perl MS Access web programming

Adam Tauno Williams members@kalamazoolinux.org
Wed, 27 Nov 2002 08:41:56 -0500


>I am working on a web site with perl and ms access as
>backend database.
>I was trying to query the ms access database from the
>perl program and when i run the perl program in the
>command line, the database queries seems to work
>fine... but when i run the perl script in the browser
>(apache webserver), the perl script is not able to
>connect to the database and it says the "cannot
>connect to database"...

Does the security contect of the web server process have sufficient privilages
to access the mdb files?  Do any required environment variables present in your
sell also exist within the environment of the web server process?  Are all
required libraries installed in locations references in /etc/ld.so.conf or are
you possibly using some LD_LIBRARY_PATH declarations?