Re: [GENERAL] Trying to install ODBC driver on Windows XP notebook
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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Trying to install ODBC driver on Windows XP notebook
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 ? regaradsGERD. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Trying to install ODBC driver on Windows XP notebook
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-ow...@postgresql.org [mailto:pgsql-general- > ow...@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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[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
