pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedODBC problem and Access 2000
2+ messages / 2 participants
[nested] [flat]
* ODBC problem and Access 2000
@ 2000-02-08 11:54 Paul Rijke <p.rijke@truckland.nl>
2000-02-09 00:31 ` Re: [INTERFACES] ODBC problem and Access 2000 Byron Nikolaidis <byron.nikolaidis@home.com>
0 siblings, 1 reply; 2+ messages in thread
From: Paul Rijke @ 2000-02-08 11:54 UTC (permalink / raw)
To: pgsql-interfaces
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 *
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: [INTERFACES] ODBC problem and Access 2000
2000-02-08 11:54 ODBC problem and Access 2000 Paul Rijke <p.rijke@truckland.nl>
@ 2000-02-09 00:31 ` Byron Nikolaidis <byron.nikolaidis@home.com>
0 siblings, 0 replies; 2+ messages in thread
From: Byron Nikolaidis @ 2000-02-09 00:31 UTC (permalink / raw)
To: p.rijke@truckland.nl; +Cc: 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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2000-02-09 00:31 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-02-08 11:54 ODBC problem and Access 2000 Paul Rijke <p.rijke@truckland.nl>
2000-02-09 00:31 ` Byron Nikolaidis <byron.nikolaidis@home.com>
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