Skip site navigation (1) Skip section navigation (2)

making contact via perl

From: "Stephen Choularton" <mail(at)bymouth(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: making contact via perl
Date: 2005-03-30 01:12:33
Message-ID: 000001c534c5$92540a30$9701a8c0@Tablet (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
I appreciate this may not be the right place to post.  If it isn’t
please advise me of the correct site.
I am using windowsXP.  I am trying to make contact with a psql database
called mydb that is on my computer.  I can do this at the prompt, viz:
C:\Documents and Settings\Stephen>psql mydb postgres
Welcome to psql 8.0.1, the PostgreSQL interactive terminal.
Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help with psql commands
       \g or terminate with semicolon to execute query
       \q to quit
Warning: Console code page (437) differs from Windows code page (1252)
         8-bit characters may not work correctly. See psql reference
         page "Notes for Windows users" for details.
And I know it is there:
mydb=# select * from weather;
     city      | temp_lo | temp_hi | prcp |    date
 San Francisco |      46 |      50 | 0.25 | 1994-11-27
 Hayward       |      37 |      54 |      | 1994-11-29
(2 rows)
but when I try to use this perl code to make contact:
use DBI;
use DBD::PgPP
my @drivers = DBI -> available_drivers();
print "this is it @drivers";
# connecting to database
my $database='mydb';
my $username = 'postgres';
my $password = '';
my $dbh = DBI->connect("DBI:PgPP:$database",
    "$username", "$password");
I get:
DBI connect('mydb','postgres',...) failed: Couldn't connect to
2:  at C:/Perl/site/lib/DBD/ line 124
 at C:\DB\ line 15

No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.8.4 - Release Date: 27/03/2005


pgsql-novice by date

Next:From: John DeSoiDate: 2005-03-30 03:15:40
Subject: Re: making contact via perl
Previous:From: CimaDate: 2005-03-29 20:48:04
Subject: Calling Stored Procedures from PHP

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group