Postgres Pro
Downloads
Home   >   mailing lists

Re: Write to postgreSQL via ODBC? - Mailing list pgsql-general

From Rudolf Potucek
Subject Re: Write to postgreSQL via ODBC?
Date
Msg-id 959chq$nr6$1@nserve1.acs.ucalgary.ca
Whole thread Raw
In response to Write to postgreSQL via ODBC?  (Rudolf Potucek <potucek@acs1.acs.ucalgary.ca>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Ian Harding
Date:
Subject: Re: SQL Join - MySQL/PostgreSQL difference?
Next
From: Raymond Chui
Date:
Subject: ON DELETE CASCADE and TRIGGER