Re: [INTERFACES] ODBC problem and Access 2000 - Mailing list pgsql-interfaces

From Byron Nikolaidis
Subject Re: [INTERFACES] ODBC problem and Access 2000
Date
Msg-id 38A0B570.17F8D260@home.com
Whole thread Raw
In response to ODBC problem and Access 2000  ("Paul Rijke" <p.rijke@truckland.nl>)
List pgsql-interfaces

Paul Rijke wrote:
> 
> Hi,
> 
> I've an ODBC problem using linked tables. With the latest ODBC version from
> ftp://ftp.postgresql.org/pub/odbc/latest everything looks allright, thanks
> to Moray McConnachie. The only thing is that I can't delete record from a
> table using the odbc driver in datagrid view. The error I get is (translated
> from dutch:( ) :
> 
> ODBC-delete has failed for linked table 'test5'.
> Error while executing the query;
> ERROR: Unable to identify an operator '=' for (#1)
> 
> When i write a query like:
> 
> delete from test5 where id=1;
> 
> from within MS Access the record get deleted perfectly.
> 
> Does anyone knows what's going wrong.
> 
> Paul Rijke
> Truckland B.V.
> Basisweg 47
> 1043 AN  AMSTERDAM
> tel: 020 - 585 1234
> fax: 020 - 585 1189
> e-mail: p.rijke@truckland.nl *
> website: http://www.truckland.nl *
> 
> ************

I need to see the driver's logfile of this event.  Also, if you could do
a "\d" on the table in question, that would help too.

Byron


pgsql-interfaces by date:

Previous
From: Bartłomiej ZNOJEK
Date:
Subject: psqlODBC and translation ISO8859-2 - WIN
Next
From: "Javi Piñol"
Date:
Subject: POR FIN DINERO REAL SIN TRAMPAS