Beefy Boxes and Bandwidth Generously Provided by pair Networks
P is for Practical
 
PerlMonks  

DBI IIS DBD::Pg

by ketema (Scribe)
on Dec 03, 2004 at 21:34 UTC ( [id://412290]=perlquestion: print w/replies, xml ) Need Help??

ketema has asked for the wisdom of the Perl Monks concerning the following question:

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.

Replies are listed 'Best First'.
Re: DBI IIS DBD::Pg
by VSarkiss (Monsignor) on Dec 03, 2004 at 22:04 UTC
      I guess that is possible, but why would the same module work from a normal script called from the command line. The same Pg.dll file is used. I will include the file on my ftp site if any one wants to test it.
      ftp://ftp.ketema.net/dbdpg.rar

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: perlquestion [id://412290]
Approved by Arunbear
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others musing on the Monastery: (2)
As of 2024-04-25 12:47 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found