You have the right list.
I believe this error message is due to access adding "=" signs in the query where postgre doesnt expect them. I think somebody here
posted a fix for this awhile back, I lost the email and would love to have this fix, as i'm sure you would too.
So if the kind gentleman/lady who posted that fix is still paying attention to the list, care to post the fix again?
Thanks in advance
Richard A. Holland
Equitech Information Systems
----- Original Message -----
From: Frodo Larik <Frodo(dot)Larik(at)diedenoort(dot)nl>
Sent: Wednesday, December 06, 2000 9:30 AM
Subject: [INTERFACES] PostgreSQL -> ODBC -> MS ACCESS
> 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 |
> sid | integer | not null default
> 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,
> 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 ...
> Frodo Larik
> You plan things that you do not even attempt because of your extreme
In response to
pgsql-interfaces by date
|Next:||From: Cassandra Stinson||Date: 2000-12-18 16:37:20|
|Previous:||From: Tom Lane||Date: 2000-12-18 14:54:13|
|Subject: Re: jdbc connectint ot db |