Re: first time odbc

Hello,

most likely you'll have to set listen_addresses in postgresql.conf
correctly as well ( see link ). Don't forget to remove the # ;)

Good luck,

Peter

Am 29.03.2011 21:27, schrieb jsilberberg(at)mindspring(dot)com:
>
>
> http://www.postgresql.org/docs/9.0/static/auth-pg-hba-conf.html
>
>
>
>
> -----Original Message-----
> From: Marc Fromm
> Sent: Mar 29, 2011 3:01 PM
> To: "jsilberberg(at)mindspring(dot)com"
> Cc: "pgsql-odbc(at)postgresql(dot)org"
> Subject: RE: [ODBC] first time odbc
>
> I updated the windows postgresql odbc drivers and now I get the message:
>
> No connection could be made because the target machine actively
> refused it.
>
>
>
> This sounds like something needs to be configured on the server to
> allow the odbc connection.
>
>
>
> *From:* jsilberberg(at)mindspring(dot)com [mailto:jsilberberg(at)mindspring(dot)com]
> *Sent:* Tuesday, March 29, 2011 11:13 AM
> *To:* Marc Fromm; pgsql-odbc(at)postgresql(dot)org
> *Subject:* Re: [ODBC] first time odbc
>
>
>
>
>
> Why,
>
>
>
> That's a vintage 02-Feb-2006 driver.
>
>
>
> I use 8.04 from Dec-2009 and even that's getting a little
> stale. Why not try the 9.n drivers.
>
>
>
> Could the port(s) be blocked / restricted between you and the
> server and is PostgreSQL SSL support enabled --
>
> http://www.postgresql.org/docs/9.0/static/ssl-tcp.html
>
>
>
> JMS
>
>
>
> -----------------------------------
>
>
>
> -----Original Message-----
> From: Marc Fromm
> Sent: Mar 29, 2011 1:58 PM
> To: "pgsql-odbc(at)postgresql(dot)org <mailto:pgsql-odbc(at)postgresql(dot)org>"
> Subject: [ODBC] first time odbc
>
>
> Before learning there was an odbc list, I sent this post to the
> admin list.
>
>
>
> I am running postgres on a red hat linux server.
>
> postgresql-python-8.1.23-1.el5_6.1
>
> postgresql-test-8.1.23-1.el5_6.1
>
> postgresql-libs-8.1.23-1.el5_6.1
>
> postgresql-docs-8.1.23-1.el5_6.1
>
> postgresql-contrib-8.1.23-1.el5_6.1
>
> postgresql-8.1.23-1.el5_6.1
>
> postgresql-pl-8.1.23-1.el5_6.1
>
> *postgresql-odbc-08.01.0200-3.1*
>
> postgresql-jdbc-8.1.407-1jpp.4
>
> postgresql-server-8.1.23-1.el5_6.1
>
> postgresql-tcl-8.1.23-1.el5_6.1
>
>
>
> User on windows computers would like to odbc to the postgres
> databases.
>
> I downloaded the windows postgres odbc drivers from the
> following site and installed version “psqlodbc-08_01_0200” on
> the windows computer.
>
> http://ftp9.us.postgresql.org/pub/mirrors/postgresql/odbc/versions/msi/
>
>
>
> When I configure a “File Data Source” connection in access, I
> cannot connect to the postgresql database. I get the message, “A
> connection could not be made using the file data source
> parameters entered. Save non-verified file DSN?”
>
> The parameters entered are:
>
> Database: database_name
>
> Server: I entered the IP address of the server
>
> User Name: I entered postgres
>
> Password:
>
> SSL Mode: prefer
>
> Port: 5432 (which is the port used by postgres)
>
>
>
> Do I need to configure the /etc/odbc.ini file? It is currently
> just a blank file.
>
>
>
> Thanks for any help.
>
>
>
> Marc
>