From: | Byron Nikolaidis <byron(dot)nikolaidis(at)home(dot)com> |
---|---|
To: | p(dot)rijke(at)truckland(dot)nl |
Cc: | pgsql-interfaces(at)postgreSQL(dot)org |
Subject: | Re: [INTERFACES] ODBC problem and Access 2000 |
Date: | 2000-02-09 00:31:44 |
Message-ID: | 38A0B570.17F8D260@home.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(dot)rijke(at)truckland(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Javi Piol | 2000-02-09 00:40:16 | POR FIN DINERO REAL SIN TRAMPAS |
Previous Message | Bartłomiej ZNOJEK | 2000-02-08 18:49:15 | psqlODBC and translation ISO8859-2 - WIN |