From: Joel Burton <jburton@scw.org>
To: Simon Hardingham <simon@netxtra.net>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: ODBC, Access and updates/deletes alter 0 rows!
Date: Wed, 2 Aug 2000 14:17:37 -0400
Message-ID: <39882D81.5378.90A4FB6@localhost> (raw)
In-Reply-To: <4DCB16536FCBD311897000A0C92A02ED19FB11@sauron.netxtra.net>
Can you post a script that will create a table with some data? This
will help debug the problem?
On 2 Aug 2000, at 18:08, Simon Hardingham wrote:
> Hi,
>
> I have been using the Postgres ODBC driver to connect from Access 97 &
> 2000 clients to postgres 6.5.3 running on Redhat 6.2 without any sort
> of problems. We have just finished upgrading to 7.0.2 and also
> updated to the latest ODBC driver, 6.50.
>
> Since then though we are having trouble making changes to fields from
> Access, ie. UPDATEs and DELETE's. Some tables seem to work fine,
> maybe limited to those which do not have many rows or fields.
> However, generally there is an update error suggesting that someone
> else has modified the data, with options to copy to clip-board etc.
> With the ODBC logging switched on I can take the SQL it is generating
> and paste this into psql and run it. This will always say that o rows
> have been updated or deleted.
>
> For all these queries the WHERE clause details the value for each of
> the fields in the table for that particular table. Is there a limit
> on the length of a query, although these seem to vary in length quite
> a lot. I can normally get it to work by removing certain of the
> fields from the where clause, seems to work best if I remove the
> clauses which are referring to float4 fields, but again may just be
> coincidence.
>
> I have looked all over the documentation for some explanation and
> changed all the ODBC driver parameters, but can't get it work
> reliably. I can supply much more information such as table layouts,
> queries, sizes, platform etc if required but I am not too sure where
> to go from here and so what might be relevant. If anyone can offer
> any help I can supply this.
>
> Thanks for any help provide and I hope I can get my screaming users
> back to work and happy again soon.
>
> Thanks
>
> Simon
>
>
> _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
> _/ Simon Hardingham - netXtra Ltd - UK _/
> _/ Tel: +44 (0) 1787 319393 Fax: +44 (0) 1787 319394 _/
> _/ http://www.netxtra.co.uk simon@netxtra.co.uk _/
> _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
--
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, simon@netxtra.net
Subject: Re: ODBC, Access and updates/deletes alter 0 rows!
In-Reply-To: <39882D81.5378.90A4FB6@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