Postgres Pro
Downloads
Home   >   mailing lists

Re: MS Access/ODBC 'ERROR: invalid input syntax for integer: "A"' - Mailing list pgsql-interfaces

From John DeSoi
Subject Re: MS Access/ODBC 'ERROR: invalid input syntax for integer: "A"'
Date
Msg-id 7F1BE9B8-9FC9-11D9-A2EC-000A95B03262@pgedit.com
Whole thread Raw
In response to MS Access/ODBC 'ERROR: invalid input syntax for integer: "A"'  (mg <postgres@ballistech.com>)
List pgsql-interfaces
Tree view 
On Mar 28, 2005, at 10:57 AM, mg wrote:

> I've searched http://search.postgresql.org/ and Google on this error 
> to no
> avail.  I suspect this problem relates to the integer / single quote 
> issue
> referenced in previous posts.  It may also relate to the domain I 
> created,
> but I'm not sure how to proceed.


What happens if you just define id as int4 rather than using the 
domain? I'm not really familiar with ACCESS/ODBC, but I'm wondering if 
it really knows anything about domains.


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

pgsql-interfaces by date:

Previous
From: mg
Date:
Subject: MS Access/ODBC 'ERROR: invalid input syntax for integer: "A"'
Next
From: Michael Goei
Date:
Subject: Re: MS Access/ODBC 'ERROR: invalid input syntax fo