I need some help figuring out some permission issues. I finally found the DBI::Pg module for WIN32 Perl v5.8 its installed and works fine from scripts. How ever I wish to use it in IIS as well. I know from searching that any scripts executing are in the IUSR context, and know that it is failing to load the Pg.dll file. Here is the exact error:
PerlScript Error error '80004005'
Can't load 'C:/Perl/site/lib/auto/DBD/Pg/Pg.dll' for module DBD::Pg: l
+oad_file:The specified module could not be found at C:/Perl/lib/DynaL
+oader.pm line 230. at (eval 3) line 3 Compilation failed in require a
+t (eval 3) line 3. (in cleanup) install_driver(Pg) failed: Can't load
+ 'C:/Perl/site/lib/auto/DBD/Pg/Pg.dll' for module DBD::Pg: load_file:
+The specified module could not be found at C:/Perl/lib/DynaLoader.pm
+line 230. at (eval 3) line 3 Compilation failed in require at (eval 3
+) line 3. Perhaps a required shared library or dll isn't installed wh
+ere expected
at first I thought it was a path problem, but after searching i know it is permissions, problem is where? I have given read and execute to the IIS process to the folder where the Pg.dll file is located, i even did a DBI trace:
DBI 1.46-ithread default trace level set to 0x0/9 (pid 476)
-> DBI->connect(dbi:Pg:dbname=mydbname;host=localhost;port=5432, a
+dministrator, ****)
-> DBI->install_driver(Pg) for MSWin32 perl=5.008004 pid=476 ruid=
+0 euid=0
What is the DBI->install_driver(Pg) call trying to do? My guess is that it needs to copy or move that file but doesn't have permission to where it needs to go. Any help would be appreciated.