Thread: Trying to install ODBC driver on Windows XP notebook

I have latest Postgresql installed on a notebook and now trying to
install the driver which I have downloaded and run so that it is now
available in the ODBC Data Source Administrator

This machine has CA security suite, latest version installed and I have
added a network rule that allows all applications using TCP and UDP on
Port 4532 to gain access In and Out

I have the correct database name and get the following message when I
try to Test the connection.

Could not connect to the server
No Connection could be made because the target machine actively refused it.
(192.168.1.7:5432)

I don't know what else I can now do to get the connection.

Any suggestions would be appreciated.

Cheers

Phil Jackson

Assuming a TCP/IP connection, does the server machine know about your tcp/ip address in pg_hba.conf?
Otherwise, what kind of connection protocol are you using?

I promise, no Lakers jokes.

> -----Original Message-----
> From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-
> owner@postgresql.org] On Behalf Of Phil Jackson
> Sent: Tuesday, June 22, 2010 1:20 PM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] Trying to install ODBC driver on Windows XP notebook
>
> I have latest Postgresql installed on a notebook and now trying to
> install the driver which I have downloaded and run so that it is now
> available in the ODBC Data Source Administrator
>
> This machine has CA security suite, latest version installed and I have
> added a network rule that allows all applications using TCP and UDP on
> Port 4532 to gain access In and Out
>
> I have the correct database name and get the following message when I
> try to Test the connection.
>
> Could not connect to the server
> No Connection could be made because the target machine actively refused
> it.
> (192.168.1.7:5432)
>
> I don't know what else I can now do to get the connection.
>
> Any suggestions would be appreciated.
>
> Cheers
>
> Phil Jackson
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general

Hi Phil,


On Tuesday, June 22, 2010 10:19:33 pm Phil Jackson wrote:
> I have latest Postgresql installed on a notebook and now trying to
> install the driver which I have downloaded and run so that it is now
> available in the ODBC Data Source Administrator
>
> This machine has CA security suite, latest version installed and I have
> added a network rule that allows all applications using TCP and UDP on
> Port 4532 to gain access In and Out

Do you really have opened port 4532, or is it a typo ? (should be 5432, of
course ;-) ).
>
> I have the correct database name and get the following message when I
> try to Test the connection.
>
> Could not connect to the server
> No Connection could be made because the target machine actively refused it.
> (192.168.1.7:5432)

Does your postmaster listen on this address ?
Check your postgresql.conf for parameter "listen_addresses"
What's the error message in detail ?

regarads....GERD.....

Phil Jackson wrote:
> I have latest Postgresql installed on a notebook and now trying to
> install the driver which I have downloaded and run so that it is now
> available in the ODBC Data Source Administrator
>
> This machine has CA security suite, latest version installed and I have
> added a network rule that allows all applications using TCP and UDP on
> Port 4532 to gain access In and Out

Is port *4532* above a typo?

> No Connection could be made because the target machine actively refused it.
> (192.168.1.7:5432)

Regards
Garry