Re: first time odbc

Is the user you connect with allowed to see / modify data?

Maybe it would be a good idea to increase the log level on the server
and look in the logs, what happens. This can be done at runtime, no
need to stop the database.

Regards,
Frank.

On Tue, 29 Mar 2011 20:21:44 +0000 Marc Fromm <Marc(dot)Fromm(at)wwu(dot)edu>
wrote:

> By editing postgresql.conf and changing listen_address = ‘*’ and
> editing pg_hba.conf and adding host all all my.ip.address allowed me
> to connect to the postgresql data base with Microsoft access.
>
> In access I can see the table and it fields, but if I try to use the
> table in a querry or view the table I get an error: permission denied
> for relation summer_finaid; error while executing the query (#7)
>
> Any ideas?
>
> Also in the postgresql instead of listen_address=’*’ I tried
> listen_address=’localhost, my.ip.address’ but that failed to work.
> How can I keep local host and only allow specific address? I don’t
> want to open it up to all with ‘*’
>
> Thanks
>
>
> 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