John, I tried a Google for your problem and got this. I know it's not exactly the error your getting but perhaps this will help us narrow the problem down.
http://perlmonks.thepen.com/16738.html Carter. > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On > Behalf Of John Deighan > Sent: Thursday, December 16, 2004 11:12 AM > To: [EMAIL PROTECTED] > Subject: RE: problems with DBD::Oracle > > > At 04:50 PM 12/15/2004, Carter Thompson wrote: > > >John, > > > >Can you run simpler CGI scripts? I see you've given permissions to > >Everyone but I wonder if something else (that would be > easier to debug) > >is causing your "access denied" errors. > > I can run CGI scripts, as long as it doesn't try to connect > to the Oracle > database. However, stand-alone scripts can connect and query > just fine. One > temporary workaround I found is that I can set up IIS to run under my > domain account (the account I'm logged in to when I run stand-alone > scripts), so I know that it is indeed a permissions problem. > However, I > can't figure out what permission I need to give to the IUSR_JDEIGHAN > account so that the CGI script will run under that account. > > > > -----Original Message----- > > > From: [EMAIL PROTECTED] > > > > [mailto:[EMAIL PROTECTED] On Behalf > > > Of John Deighan > > > Sent: Wednesday, December 15, 2004 12:59 PM > > > To: [EMAIL PROTECTED] > > > Subject: problems with DBD::Oracle > > > > > > > > > I'm trying to get my web site working with an Oracle > database (I've > > > been using SQL Server through DBD::ODBC). Although stand alone > > > scripts can successfully access the remote Oracle > database, my web > > > site, running under > > > IIS, can't. I get a 500 server error, and in the Perl log > file, I get: > > > > > > *** 'c:\wwwroot\empty\default.plx' log message at: 2004/12/15 > > > 15:53:06 > > > Precompiler: CORE::require failed $@ = 'Can't load > > > 'C:/Perl/site/lib/auto/DBD/Oracle/Oracle.dll' for module > DBD::Oracle: > > > load_file:Access is denied at C:/Perl/lib/DynaLoader.pm line 229. > > > at (eval 95) line 3 > > > Compilation failed in require at (eval 95) line 3. > > > ' result = '' > > > Precompiler: Execute Error: > > > Filename:[c:\wwwroot\empty\default.plx] > > > > Package:[PerlEx::Precompiler::c_::wwwroot::empty::default_plx] > > > Params[] > > > DbConn: Unable to open database connection for user > 'easyiep' source > > > 'LocalServer'install_driver(Oracle) failed: Can't load > > > 'C:/Perl/site/lib/auto/DBD/Oracle/Oracle.dll' for module > DBD::Oracle: > > > load_file:Access is denied at C:/Perl/lib/DynaLoader.pm line 229. > > > at (eval 95) line 3 > > > Compilation failed in require at (eval 95) line 3. > > > Perhaps a required shared library or dll isn't installed > > > where expected > > > at c:/PerlLibs/DbConn.pm line 62 > > > > > > > > > I've taken the DLL mentioned, and given full control to Everyone, > > > SYSTEM, and IUSR_JDEIGHAN (the account that my web site is running > > > under). Can > > > anyone figure out what's wrong? > > > > > > OS: Microsoft Windows 2000 Server > > > Perl: ActivePerl 5.8.3 > > > DBI: 1.46 > > > DBD-Oracle: 1.12 > > > > > > _______________________________________________ > > > Perl-Win32-Users mailing list > > > [EMAIL PROTECTED] > > > To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs > > > > > > >_______________________________________________ > >Perl-Win32-Users mailing list > [EMAIL PROTECTED] > >To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs > > _______________________________________________ > Perl-Win32-Users mailing list > [EMAIL PROTECTED] > To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs > _______________________________________________ Perl-Win32-Users mailing list [EMAIL PROTECTED] To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs