From: npdavis@hotmail.com
To: jburton@scw.org
Cc: pgsql-interfaces@postgresql.org
Subject: Re: PostgreSQL ODBC driver: recordset not updatable
Date: Tue, 05 Dec 2000 03:02:10
Message-ID: <F250axXnvBW8II9jNkX00005c3d@hotmail.com> (raw)
Joel,
I love it when I am proved wrong and another resource is dumped into my lap!
That is how I learn. I admit I was generalizing. I did a little research
into odbc on windows after I wrote that and found that the MySQL driver
works really well. Open source ODBC on windows has come a long way since I
last played with it.
thanks!
Neil
>From: "Joel Burton" <jburton@scw.org>
>To: "Neil Davis" <npdavis@hotmail.com>
>CC: <pgsql-interfaces@postgresql.org>
>Subject: Re: [INTERFACES] PostgreSQL ODBC driver: recordset not updatable
>Date: Mon, 4 Dec 2000 17:00:30 -0500
>
>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)
_____________________________________________________________________________________
Get more from the Web. FREE MSN Explorer download : http://explorer.msn.com
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, jburton@scw.org
Subject: Re: PostgreSQL ODBC driver: recordset not updatable
In-Reply-To: <F250axXnvBW8II9jNkX00005c3d@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