From: | Andy Glew <andyfives(at)yahoo(dot)co(dot)uk> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Problem with connectivity |
Date: | 2007-10-04 16:12:55 |
Message-ID: | 809243.45915.qm@web27614.mail.ukl.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Please help.. I have hit a bit of a brick wall with this.
I have a problem concerning connecting to my database. I want to log webserver transactions into a postgresql db. For development the webserver is my local pc and the postgresql db is setup on a server, both accessable through the companies network.
This is in a windows XP environment.
Now when I try to access the db through my webpage (generated using perls Template Toolkit) I get the following:-
DBI connect failed: Couldn't connect to cphnbdev3:5432/tcp: IO::Socket::INET: connect: Unknown error at C:/Perl/site/lib/DBD/PgPP.pm line 124
My connection string shouldn't be much of a problem as I use something similar (different port granted) for our MySQL db.
DBI:mysql:database=skylightslogs;host=Cphxxdev;port=3306
To start with I installed postgresql on my local PC and managed to get it to work just fine using the DBI utility.
I am a newby with postgresql, generally very impressed but would like some help in solving my little problem... What could be wrong, I tried changing the port, the host name in the pgAdminIII and loads of other things too?
Thanks in advance
___________________________________________________________
Want ideas for reducing your carbon footprint? Visit Yahoo! For Good http://uk.promotions.yahoo.com/forgood/environment.html
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Marlowe | 2007-10-04 16:21:07 | Re: good sql tutorial |
Previous Message | Geoffrey | 2007-10-04 16:06:23 | Re: good sql tutorial |