Re: ODBC & Access [Try 2]

Liam,

> Can I ask you a question? Is your Postgres running on a
> windows machine? or Linux/unix?

FreeBSD.

--------------------------
David Olbersen
iGuard Engineer
11415 West Bernardo Court
San Diego, CA 92127
1-858-676-2277 x2152


> -----Original Message-----
> From: Liam DeMasi [mailto:ldemasi@acsinc-nj.com]
> Sent: Friday, April 25, 2003 7:43 AM
> To: David Olbersen
> Subject: RE: [ODBC] ODBC & Access [Try 2]
>
>
>
> Hello,
>
> Can I ask you a question? Is your Postgres running on a
> windows machine? or Linux/unix?
>
> -----Original Message-----
> From: pgsql-odbc-owner@postgresql.org
> [mailto:pgsql-odbc-owner@postgresql.org]On Behalf Of David Olbersen
> Sent: Friday, April 25, 2003 10:36 AM
> To: pgsql-odbc@postgresql.org
> Subject: [ODBC] ODBC & Access [Try 2]
>
>
> I'm trying to use Access as a front end for Postgres. This is
> mainly for data-entry and manual updates.
>
> I was able to establish an ODBC connection to the server
> without any problems. I was also able to link the tables that
> I need. I linked 8 tables total.
>
> 7 of them work just fine and I can see all the data in them.
> The last one though, only displays '#DELETED' for each column
> of each row. I checked the permissions on all the tables and
> they're the same -- I have read access (all I need for now, right?)
>
> Any idea what's going on? This is PostgreSQL 7.3.2 on FreeBSD
> with the PostgreSQL ODBC driver version 7.02.00.05 on Win XP.
>
> I've also tried the snapshot driver version: 7.03.00.01 with
> now change. I've also disabled the 'updateable cursors'
> option for the DSN.
>
> Any suggestions are more than welcome.
>
> --------------------------
> David Olbersen
> iGuard Engineer
> 11415 West Bernardo Court
> San Diego, CA 92127
> 1-858-676-2277 x2152
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
>