Why cant I load Pg module from my perl CGI under IIS? - Mailing list pgsql-cygwin

From Rishi Sharma
Subject Why cant I load Pg module from my perl CGI under IIS?
Date
Msg-id F902091518C1D411985D0008C7E6566C01FE0611@ned.bigstep.net
Whole thread Raw
List pgsql-cygwin
I can run the following test script in a dos shell by typing:
>perl test.pl

Contents of test.pl:
#!/usr/bin/perl
# -*- perl -*-   to tell emacs that this is a perl script

## uncomment for cgi ###
#use CGI;
#print header;

use Pg;

$conn = Pg::connectdb("dbname=intake");

$status=$conn->status;
if ($status != PGRES_CONNECTION_OK) {
    print STDERR "Error fatal en la conexion ($status), terminamos\n";
    exit (1);
}

    Pg::doQuery($conn, " select * from tbl_checklist", \@arreglo);
    foreach my $i (0 .. $#arreglo) {
        foreach my $j (0 .. $#{$arreglo[$i]}) {
            print "$arreglo[$i][$j]\t";
        }
        print "\n";
    }
exit (0);


however, when I convert to cgi this script, it just hangs in my browser.
What could be wrong with my IIS environment.  The system has all the path,
ld_library_path, pgdata, pdlib variables set.

How can I test if Pg is infact in my web server's environment.

Best,

Rishi Sharma.


pgsql-cygwin by date:

Previous
From: Rishi Sharma
Date:
Subject: RE: RE: RE: tourble migrating from linux/Apache/postgres ql/perl to win2000/IIS/postgresql/perl
Next
From: s0lao@netscape.net (S. L.)
Date:
Subject: Re: RE: RE: RE: tourble migrating from linux/Apache/postgresql/perl to win2000/IIS/postgresql/perl