Hi,

I've tried to use DBI with Postgre but the result was:

DBD::PgPP::st execute failed: Unknown message type: ' at ./connect.cgi line26.
execute was not possible: Unknown message type: '' at 
/home/uso/dbi/i586-linux/DBD/PgPP.pm line 634

here is the script (connect.cgi):

#! /usr/bin/perl

use strict;
use lib "$ENV{HOME}/dbi/i586-linux";  
use DBI;
use CGI;

my $dbdriver = "PgPP";
my $dbname   = "uso";
my $host     = "blue.local";
my $port     = "5432";
my $username = "uso_admin";
my $password = "pwd";


my $dbh = DBI->connect(
     "dbi:$dbdriver:dbname=$dbname;host=$host;port=$port",
     $username, $password
) or die "connect fails: " . $DBI::errstr;

my $sth = $dbh->prepare('SELECT * FROM MEMBERS')
          or die "prepare was not possible: " . $dbh->errstr();

$sth->execute()  # <-- error (line 26) --------
          or die "execute was not possible: " . $sth->errstr();



any help would be appreciated !!

Best Regards,
:-)hris



-- 
Christian Kaiser
Ligastra�e 4, Geisling

D - 93 102 PFATTER

Tel.: +49 9481 959004
Cel.: +49 173 3525082

Reply via email to