Problem connect to DBD::PgPP <--> Perl

Hi
I am trying to connect via DBI to a PostgresPlus server.

I get the following error:
---------------------------
DBI->connect('dbname=$dbname; host=$host; port=$port','$username',...) failed:
Couldnt connect to /tmp/.s.PGSQL.5432: at C:/Perl/site/lib/DBD/PgPP.pm
------------------------------
I tried to connect PostgresPlus server both in winXP and linux using perl script.Both machines prompt me above error message.
My client pgAdminIII is in winXP.Using pgAdminIII i able to connect to server in both machine.
Here is code snippet:
---------------------------------------
I set up DBD-PgPP via PPM.
---------------------------------------
Any ideas as to what I am missing.

my $conn = DBI->connect("dbi:PgPP:dbname=$dbname; host=$host;port=$port" ,"$username", "password",{ RaiseError => 1, AutoCommit => 0});

Open in new window

LVL 7
tankergoblinAsked:
Who is Participating?
 
RawdustCommented:
0
 
msklizmantasCommented:
hello,

what data are you passing to $host? looks like script tries to use socket to connect to pg server..

best regards,
m
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.