Re: Trying to install ODBC driver on Windows XP notebook

Started by Dann Corbitalmost 16 years ago3 messagesgeneral

DCorbit@connx.com

almost 16 years ago

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.

Show quoted text

-----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

Import Notes

Reply to msg id not found: 4C211AD5.3080009@clear.net.nzReference msg id not found: 4C211AD5.3080009@clear.net.nz

Gerd Koenig

koenig@transporeon.com

almost 16 years ago

In reply to: Dann Corbit (#1)

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.....

Import Notes

Reply to msg id not found: 4C211AD5.3080009@clear.net.nzReference msg id not found: 4C211AD5.3080009@clear.net.nz | Resolved by subject fallback

Garry Saddington

garry@schoolteachers.co.uk

almost 16 years ago

In reply to: Gerd Koenig (#2)

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

Import Notes

Reply to msg id not found: 4C211AD5.3080009@clear.net.nzReference msg id not found: 4C211AD5.3080009@clear.net.nz | Resolved by subject fallback