Re: Re: Write to postgreSQL via ODBC?

Another thing is that sometimes after you reconfigure an ODBC driver, you
need to relink your tables.

Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
http://www.rutgersinsurance.com
----- Original Message -----
From: "Rudolf Potucek" <potucek@acs1.acs.ucalgary.ca>
To: <pgsql-general@postgresql.org>
Sent: Wednesday, January 31, 2001 10:55 AM
Subject: [GENERAL] Re: Write to postgreSQL via ODBC?


> In comp.databases.ms-sqlserver Craig Orsinger
<cjorsinger@earthlink_net.invalid> wrote:
>
>
> : Rudolf Potucek wrote:
> :>
> :> I've got the postgres ODBC driver installed and can connect to it from
> :> MS Excel 97. However it seems I can only execute queries (read data)
but
> :> not save data. Is that a limitation of Excel or of the ODBC approach?
>
> : When you set up your DSN on the Windows box, did you uncheck
> : the box in Advanced Options named "ReadOnly (Default)" ? For some
> : reason, the PostgreSQL ODBC driver defaults to only being able to do
> : queries.
>
> I did. I subsequently tried this with Access and I can actually create
> new tables that way ... now I just have to figure out how to do an UPDATE
> instead ...
>
> Thx,
>
>   Rudolf