Re: first time odbc
От | Jan-Peter Seifert |
---|---|
Тема | Re: first time odbc |
Дата | |
Msg-id | 4D923E11.9060108@gmx.de обсуждение исходный текст |
Ответ на | Re: first time odbc ("jsilberberg@mindspring.com" <jsilberberg@mindspring.com>) |
Список | pgsql-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@mindspring.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@mindspring.com" > Cc: "pgsql-odbc@postgresql.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@mindspring.com [mailto:jsilberberg@mindspring.com] > *Sent:* Tuesday, March 29, 2011 11:13 AM > *To:* Marc Fromm; pgsql-odbc@postgresql.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@postgresql.org <mailto:pgsql-odbc@postgresql.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 >
В списке pgsql-odbc по дате отправления: