Message-ID: <3A2E5B7E.E2150958@diedenoort.nl>
Date: Wed, 06 Dec 2000 16:30:06 +0100
From: Frodo Larik <Frodo.Larik@diedenoort.nl>
MIME-Version: 1.0
To: pgsql-interfaces@postgresql.org
CC: Frodo.Larik@diedenoort.nl
Subject: PostgreSQL -> ODBC -> MS ACCESS 
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

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.