Re: PostgreSQL ODBC driver: recordset not updatable

Evelio,
ODBC drivers on Micro$oft windows, typically do not support update, delete
or insert (db modification) through them when used against non-microsoft
databases. Part of the price you pay for ODBC. You will have to write server
side functions and execute them through the odbc connections like:

cnn_postgresql_ado_connection.Execute("SELECT function_name('" + arg1 + "',
'" + arg2 + "', '" + arg3 + "');")

using vba.

Try all three types of query before writing lots of functions. ODBC may
support some of them.

You simply write a parameterized function. In this function you put your
update, insert, or delete query. When you execute through ODBC it will work.

Details are in the PostGreSQL online manual. Get the searchable PDF that
Bruce Momjian is writing. It is excellent. It got me through 90% of the
platform specific stuff that I needed to learn.

L8,
Neil

----- Original Message -----
From: "Evelio Martinez" <evelio(dot)martinez(at)testanet(dot)com>
To: <pgsql-interfaces(at)postgresql(dot)org>
Sent: Monday, December 04, 2000 1:44 PM
Subject: [INTERFACES] PostgreSQL ODBC driver: recordset not updatable

>
>
> Hi!
>
> I have installed the postgresql ODBC driver (6.5) under W98 and I am
> trying to access the PostgreSQL 7.0.2 database on Linux
> but I cannot edit or modify the data from MS Access 2000.
>
> The Readonly check box is not marked, so ?
>
> Is this a bug ?
> Are the components incompatible?
>
> Any help will be appreciated.
>
> Evelio
>
>