Обсуждение: Write to postgreSQL via ODBC?

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?

Rudolf

Neither, I would think.  The most probable cause is
that your driver is configured for read only access.

Open the ODBC Administration application. (I think
it's at C:\WINDOWS\SYSTEM\ODBCAD32.EXE).  Select your
PostgreSQL driver and click on the configure button.

A window will popup with various configuration
options.  Under Options(Advanced), there should be a
button labelled "DataSource".  Click on the DataSource
button and look for a check box labelled "ReadOnly".
Make sure that "ReadOnly" is NOT checked.

Perform these steps for all PostgreSQL connections
that you have created.

I hope this helps,

Andrew Gould


--- Rudolf Potucek <potucek@acs1.acs.ucalgary.ca>
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?
>
> Rudolf
>


__________________________________________________
Get personalized email addresses from Yahoo! Mail - only $35
a year!  http://personal.mail.yahoo.com/

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 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

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