Re: MS Access/ODBC 'ERROR: invalid input syntax fo

From: John DeSoi <desoi(at)pgedit(dot)com>
To: Michael Goei <postgres(at)ballistech(dot)com>
Cc: "'pgsql-interfaces(at)postgresql(dot)org'" <pgsql-interfaces(at)postgresql(dot)org>
Subject: Re: MS Access/ODBC 'ERROR: invalid input syntax fo
Date: 2005-03-29 01:13:59
Message-ID: D454386C-9FEF-11D9-A2EC-000A95B03262@pgedit.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces


On Mar 28, 2005, at 5:06 PM, Michael Goei wrote:

> Does anyone have any ideas as to how to get the MS Access / ODBC
> connection
> to use the proper SELECT syntax when selecting on a primary key field
> defined as a domain (with the underlying type as int4)?

My only other ideas are (1) to try a different client program to see if
you can determine if the problem lies with Access or the ODBC driver
(2) repost your question to the ODBC list.

John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL

In response to

Browse pgsql-interfaces by date

  From Date Subject
Next Message Frank Bax 2005-03-29 12:30:48 DBD::PG question
Previous Message Michael Goei 2005-03-28 22:06:00 Re: MS Access/ODBC 'ERROR: invalid input syntax fo