Using DBD::ODBC in a CGI script under Apache

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

• Using DBD::ODBC in a CGI script under Apache by scarmalt
• Re: Using DBD::ODBC in a CGI script under Apache by scarmalt
• Re: Using DBD::ODBC in a CGI script under Apache by Martin J. Evans
• Re: Using DBD::ODBC in a CGI script under Apache by Ron Savage