PostgreSQL -> ODBC -> MS ACCESS

From: Frodo Larik <Frodo(dot)Larik(at)diedenoort(dot)nl>
To: pgsql-interfaces(at)postgresql(dot)org
Cc: Frodo(dot)Larik(at)diedenoort(dot)nl
Subject: PostgreSQL -> ODBC -> MS ACCESS
Date: 2000-12-06 15:30:06
Message-ID: 3A2E5B7E.E2150958@diedenoort.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

Dear Reader,

This is my first post to this list. I just hope this is the right one
:-)

i'm having a problem with the ODBC connection from PostgreSQL to Access,
this is what I'm using:

PostgreSQL: 7.02 (Debian/GNU Linux binary)
MS Access: 97
ODBC: PostgreSQL ODBC driver on Win32

This is how the table fields looks like this:

=======================
helpdesk=# \d storingen
Table "storingen"
Attribute | Type |
Modifier
------------------+---------+-----------------------------------------------------
sid | integer | not null default
nextval('storingen_sid_seq'::text)
gemeld_by | text | not null
datum | date | not null
tijd | time | not null
ruimte | text | not null
omschrijving | text | not null
aktie_door | text |
response | text |
afgehandeld | text |
afgehandeld_door | text |
Indices: storingen_idx,
storingen_sid_key
=======================

This is what is happening:

With Access I enter data into the table via an form, this works all ok
when only entering new data. When afterwarts I want to change data in a
already made record OR try to delete the record I get this:

(I see this as a pop-up window in access or on the console of the
postgresql-server running linux)

ERROR: Unable to identify an operator '=' for types 'xid' and 'int4'
You will have to retype this query using an explicit cast (#1)

Well I don't know how to fix it, Looked through mailinlists, newsgroups
etc.., but I can't find a proper solution.

I would appreciate If anyone has an solution for this problem, or a
suggestion ...

Sincerly,

Frodo Larik

--
You plan things that you do not even attempt because of your extreme
caution.

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message Randy Jonasz 2000-12-06 21:48:36 RFC C++ Interface
Previous Message Dave Page 2000-12-06 12:15:01 pgAdmin v7.0.4 Released