Re: Write to postgreSQL via ODBC?

From: Craig Orsinger <cjorsinger(at)earthlink_net(dot)invalid>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Write to postgreSQL via ODBC?
Date: 2001-01-31 09:25:40
Message-ID: 3A77D94B.76424B0B@earthlink_net.invalid
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

There's some useful information about all this in the
PostgreSQL FAQ at:

http://www.postgresql.org/users-lounge/docs/faq.html

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Evelio Martinez 2001-01-31 10:56:40 Bug with serial columns
Previous Message cwz 2001-01-31 09:08:41 Re: How do I list all tables?