Re: Using DBD::ODBC in a CGI script under Apache

On Thu, 2006-07-06 at 19:45 +0200, scarmalt@xxxxxx wrote:
I'm having a problem getting DBD::ODBC to work when invoked from a cgi
script (running under Apache).

Specifics ---

I have a test program which can be called from two different "drivers".
One is run from the command prompt:

>perl test_sql_flat.pl

The other from cgi script

http://development.server.in-house/cgi-bin/test_sql_page.pl

These scripts call a common module to do a simple DBI SELECT test.

The common module can be configured to use either an ODBC interface or an
Oracle interface.

Both work without problems when launched from the command prompt after
logging in as the web user.
But when invoked from a cgi setting, only the Oracle request works; the
ODBC returns

DBI connect('db2adrs','odbcread',...) failed: Specified driver could
not be loaded (SQL-IM003)(DBD: db_login/SQLConnect err=-1)

Any suggestions on how to fix this will be most welcome.

Thanks and regards,
Sam Carmalt

What platform are you running the CGI on?
I'm guessing UNIX but only from the command prompt shown above

What is the ODBC driver?
DB2? if so it will need DB2INSTANCE setting and exporting from you
Apache config although if this was the reason for the failure you'd get
a different error - like failed to allocate environment.

Are you using an ODBC driver manager and if so which one?

It is probably and environment issue. Something in you environment when
you log is a your web user which is required to load your driver which
is not passed on to CGI scripts by default - like LD_LIBRARY_PATH - see
SetEnv in the Apache configuration guide and examine your environment
when logged in as your webuser by running env.

Martin
--
Martin J. Evans
Easysoft Limited
http://www.easysoft.com

.

Relevant Pages

  • Re: Scanner not showing up in Control Panel/Scanners and Cameras
    ... shared with the scanner files. ... Windows XP install to correct the problem may be neccassary. ... Windows cannot load the device driver for this hardware. ... At a command prompt, type the following command, and then press ENTER: ...
    (microsoft.public.windowsxp.help_and_support)
  • Re: ISE/EDK Kubuntu linux installation issues
    ... Note this applies to the USB driver. ... Next download the userspace shim sources from http://www.rmdir.de/~michael/xilinx/ and compile them. ... Ensure the script permissions are set with chmod +x. ... By putting an executable shell script directly in the places where callers look for it, you can add the prelink and the Linux system libaries will sort out whether it's executing a binary or a shell script. ...
    (comp.arch.fpga)
  • Re: Command Prompt
    ... by updating my video card driver the problem went ... If you have problems with the PC rebooting when you open the ... "command prompt", you may wish to update your video card drivers - although ...
    (microsoft.public.windowsxp.help_and_support)
  • Re: vbs to configure printer to remote machine
    ... Description The printer driver is unknown. ... Win32 error code 1797 ... copy the files you want to install into this directory. ... Microsoft Windows Script Host Version 5.6 ...
    (microsoft.public.windowsxp.print_fax)
  • SUMMARY : With code (LONG) Jass Drivers / Finish scripts
    ... You should probably be using the undo functionality of jass. ... and then re-install jass Main Driver ... Make a wrapper script that looks at all the finish scripts ... Would have liked to make this run on the client but could not figure this bit ...
    (SunManagers)