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

Re: MS Access/ODBC 'ERROR: invalid input syntax for integer: "A"'

From: John DeSoi <desoi(at)pgedit(dot)com>
To: mg <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 for integer: "A"'
Date: 2005-03-28 20:39:35
Message-ID: 7F1BE9B8-9FC9-11D9-A2EC-000A95B03262@pgedit.com (view raw or flat)
Thread:
Lists: pgsql-interfaces
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


In response to

pgsql-interfaces by date

Next:From: Michael GoeiDate: 2005-03-28 22:06:00
Subject: Re: MS Access/ODBC 'ERROR: invalid input syntax fo
Previous:From: mgDate: 2005-03-28 15:57:19
Subject: MS Access/ODBC 'ERROR: invalid input syntax for integer: "A"'

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