From: Joel Burton <jburton@scw.org>
To: Neil Davis <npdavis@hotmail.com>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: PostgreSQL ODBC driver: recordset not updatable
Date: Mon, 4 Dec 2000 17:00:30 -0500
Message-ID: <3A2BCDAE.1011.174999C@localhost> (raw)
In-Reply-To: <OE29cn8TtEvzoxJ6sJ9000010a8@hotmail.com>
On 4 Dec 2000, at 15:18, Neil Davis wrote:
> 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:
In MS Access, you can update, delete, insert, either by (a) direct
linked tables, or (b) ODBCDirect. You can't when using "Pass-
through queries".
In VB, when I simply bind a data object to a PG recordset, that's
updatable too.
You might want to look into your problem; I don't know exactly
what you've been trying w/ODBC + PG, but, in at least several
areas, I've been able to update recordsets w/o problem and w/o
parameterized queries.
http://www.scw.org/pgaccess may have some helpful info. It's
mostly Access-focused, but has general info about ODBC + PG.
Good luck!
--
Joel Burton, Director of Information Systems -*- jburton@scw.org
Support Center of Washington (www.scw.org)
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: jburton@scw.org, npdavis@hotmail.com
Subject: Re: PostgreSQL ODBC driver: recordset not updatable
In-Reply-To: <3A2BCDAE.1011.174999C@localhost>
* 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