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

From Andrew Gould
Subject Re: Write to postgreSQL via ODBC?
Date
Msg-id 20010205213204.21973.qmail@web117.yahoomail.com
Whole thread Raw
In response to Write to postgreSQL via ODBC?  (Rudolf Potucek <potucek@acs1.acs.ucalgary.ca>)
List pgsql-general
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/

pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: 7.1beta4 initdb problem
Next
From: Art Taylor
Date:
Subject: GUI Clients for PostgreSQL