Message-ID: <002501c05ecf$2123a800$330a0a0a@6014cwpza006>
From: "Adam Lang" <aalang@rutgersinsurance.com>
Cc: <pgsql-interfaces@postgresql.org>
References: <3A2BCDAE.1011.174999C@localhost>
Subject: Re: PostgreSQL ODBC driver: recordset not updatable
Date: Tue, 5 Dec 2000 10:21:31 -0500
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

I agree.  Microsoft has no control over how someone makes their ODBC driver.
Sometimes people blame them [Microsoft] for more than they do.

Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
http://www.rutgersinsurance.com
----- Original Message -----
From: "Joel Burton" <jburton@scw.org>
To: "Neil Davis" <npdavis@hotmail.com>
Cc: <pgsql-interfaces@postgresql.org>
Sent: Monday, December 04, 2000 5:00 PM
Subject: Re: [INTERFACES] PostgreSQL ODBC driver: recordset not updatable


> 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)