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