Thread: ODBC, Access and updates/deletes alter 0 rows!

ODBC, Access and updates/deletes alter 0 rows!

From
"Simon Hardingham"
Date:
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 _/
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/



Re: ODBC, Access and updates/deletes alter 0 rows!

From
"Joel Burton"
Date:
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)