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