Skip site navigation (1) Skip section navigation (2)

Re: PostgreSQL -> ODBC -> MS ACCESS

From: "Richard Holland" <rholland(at)equitechinfo(dot)com>
To: <pgsql-interfaces(at)postgresql(dot)org>
Subject: Re: PostgreSQL -> ODBC -> MS ACCESS
Date: 2000-12-18 15:31:34
Message-ID: 004b01c06907$9de211a0$bb01a8c0@equitech (view raw or flat)
Thread:
Lists: pgsql-interfaces
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
CCNP,MCSE,CCDA
Equitech Information Systems
417.832.0366
----- Original Message -----
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>
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   |
> 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.


In response to

pgsql-interfaces by date

Next:From: Cassandra StinsonDate: 2000-12-18 16:37:20
Subject:
Previous:From: Tom LaneDate: 2000-12-18 14:54:13
Subject: Re: jdbc connectint ot db

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group