[SQL] connecting to postgres server from Access

2001-01-10 Thread Markus Wagner
Hi, I'm running a postgres db server on my linux machine. Someone else would like to build his frontends with MS Access and use the postgres server as backend. He installed the Pg/ODBC-Driver linked to at the pg web site. But when he tries to link in some table he always gets an error message

Re: [SQL] connecting to postgres server from Access

2001-01-10 Thread Joel Burton
On Wed, 10 Jan 2001, Markus Wagner wrote: > Hi, > > I'm running a postgres db server on my linux machine. Someone else would like > to build his frontends with MS Access and use the postgres server as backend. > He installed the Pg/ODBC-Driver linked to at the pg web site. But when he > tries

Re: [SQL] connecting to postgres server from Access

2001-01-11 Thread Markus Wagner
Hi Joel, first of all, I looked at the mailing list list at th pg web site and I did not find a list named "pgsql-interfaces". In pg_hba.conf I added one line at the bottom with the IP of the client: host all 134.93.64.47 255.255.255.255 trust In Access, after installing the

Re: [SQL] connecting to postgres server from Access

2001-01-11 Thread Joel Burton
On Thu, 11 Jan 2001, Markus Wagner wrote: > first of all, I looked at the mailing list list at th pg web site and I > did not find a list named "pgsql-interfaces". Hmmm. I see it at http://www.postgresql.org/users-lounge/index.html Perhaps you looked elsewhere, or you saw an old mirror? (In

Re: [SQL] connecting to postgres server from Access

2001-01-12 Thread Markus Wagner
Hi Joel! > http://www.postgresql.org/users-lounge/index.html Ok, my fault... > > "cannot create index for the selected field" > > > > Then the linked table appears in the tables tab in Access. When trying > > to open it, I get ("Organisation" is the table to be linked): > > > > "ODBC error: >