Hi Dave. I've just reset permissions on my perl tree and it hasn't made a difference. I've also reduced the code to 2 lines:
use DBI; use DBD::ODBC; and I still get the failure. I'm using Activeperl 5.6.0 build 620 on WinNT Terminal server edition SP6 (plus a variety of hotfixes). Incidentally when a run these two lines of code on a W2K pro machine with Activeperl 5.6.1 build 635 I don't have a problem. It's looking more likely that I may have to upgrade the perl install on the WinNT machine but there are a lot of scripts that will have to be retested! I just tried filemon as suggested by Kevin Gould. What it's showing me is that it's able to successfully read the D:/Perl/site/lib/auto/DBD/ODBC/ODBC.dll file. It seems that that DLL is then instructing it to load odbc32.dll. It tries finding this in the d:\perl\site\lib\auto\dbd\odbc directory then in the current working directory. Filemon then indictates that perl script is then going through it's 'carp' stuff and that it's not trying to find the odbc32.dll file anywhere else in the path. Obviously this file is in the system 32 directory and this is the first thing in my path variable. I've copied the odbc32.dll into the current directory and things go further but then it wants to load more DLL's. I figure rather than start copying files everywhere someone may know what is wrong here? The unprivileged user does have rights to the c:\wtsrv\system32 directory so that doesn't appear to be the problem. In response to Kens question I did restart the apache service each time. i don't think I need to reboot the box as when I added the apache user to the administrators group then restarted the service the script works. Has anyone got any more ideas as to how I can fix this? By the way Dave could I direct you to my post here: http://aspn.activestate.com/ASPN/Mail/Message/perl-win32-admin/1538144 It's in regards to an issue I'm having with Win32::Perms. I don't want to have to shell out to cacls if I can at all help it :) Thanks again, PJ --- Dave Roth <[EMAIL PROTECTED]> wrote: > Does it work if you apply (at least) read > permissions on the entire Perl > tree to the Everyone SID? > > -----Original Message----- > From: Paul Jansen [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, February 19, 2003 11:51 PM > To: [EMAIL PROTECTED] > Subject: unprivileged userID's and loading DLL's > > > This is infuriating me. I've done lots of web > searches with various terms and have come up with > nothing but the same question from others. I'm > hoping > someone might be able to help? > > I'm running a perl script as a CGI-app under apache > on > a windows NT box. Apache is running is a regular > pleb > user with not many rights. The script wants to use > DBD::ODBC to get at an access database on the local > machine. > I get this error: > > Can't load 'd:/Perl/site/lib/auto/DBD/ODBC/ODBC.dll' > for module DBD::ODBC: load_file:Access is denied at > d:/Perl/lib/DynaLoader.pm line 200. at > d:\apache\cgi-bin\DISK_S~2.PL > line 8 Compilation failed in require at > d:\apache\cgi-bin\DISK_S~2.PL > line 8. BEGIN failed--compilation aborted at > d:\apache\cgi-bin\DISK_S~2.PL line 8. > > I've logged on as the apache user and verified that > it > has rights to get at this dll. It had read rights > and > I even changed it to 'full control' but that didn't > make any difference. If I put the apache user in > the administrators > group the script runs fine so obviously this si a > 'rights' issue. I've > gone through the advanced user rights and I tried > 'load and unload > device drivers' but giving that to the apache user > hasn't helped. Surely > someone has come across this before and found a fix. > Thanks in advance > for any tips to solve this one! > > PJ http://mobile.yahoo.com.au - Yahoo! Mobile - Exchange IMs with Messenger friends on your Telstra or Vodafone mobile phone. _______________________________________________ Perl-Win32-Admin mailing list [EMAIL PROTECTED] To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
