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

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 (view raw or flat)
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

pgsql-interfaces by date

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

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