On Wed, 12 Mar 2003, Jay G. Scott wrote:
> Greetings,
>
> My code follows. Should be enough for some bright person to figure
> out what I'm doing wrong. To me, it all looks fine.
>
>
> #!/usr/bin/perl
>
> use DBI;
> use Pg;
You don't need Pg methinks.
> use Getopt::Std;
>
> $DBSERVER="torn.arlut.utexas.edu";
> $USERNAME="postgres";
> $PASSWORD="";
> $dbh = DBI->connect("DBI:PgPP:database=test;host=$DBSERVER", $USERNAME, $PASSWOR
> D)
> or die "Can't connect to database: $dbh->errstr\n";
>
If you can, try using DBD::Pg. I don't know much about DBD::PgPP but it
is at version .04, so I don't know if it is production quality code.
If you can't use DBD::Pg, post a trace ($dbh->trace(2)).
HTH,
-r
