From: Neil Davis <npdavis@hotmail.com>
To: Evelio Martinez <evelio.martinez@testanet.com>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: PostgreSQL ODBC driver: recordset not updatable
Date: Mon, 4 Dec 2000 15:18:57 -0500
Message-ID: <OE29cn8TtEvzoxJ6sJ9000010a8@hotmail.com> (raw)
References: <3A2BE607.4C268EA6@testanet.com>
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.martinez@testanet.com>
To: <pgsql-interfaces@postgresql.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
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: npdavis@hotmail.com, evelio.martinez@testanet.com
Subject: Re: PostgreSQL ODBC driver: recordset not updatable
In-Reply-To: <OE29cn8TtEvzoxJ6sJ9000010a8@hotmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox